Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Sum + If Array
I recently attended your excel for data analysis class. I have a question regarding the sum+if example. Can you please walk me through the logic behind the array in the sum + boolean example (approach 4)? In other words, how does * connect the three formulas? Everything else makes sense and I get it...
I recently attended your excel for data analysis class. I have a question regarding the sum+if example. Can you please walk me through the logic behind the array in the sum + boolean example (approach 4)? In other words, how does * connect the three formulas? Everything else makes sense and I get it.
Read More
Show All 1 Replies
Login to Reply
0
by Guest 1.
added 11 years ago
