Philistine needs help creating loop.
Updated: Hey everybody - new to excel and doin' my best, but could use your help. Dumbing it down for my own sake, I need to create a function that will check multiple criteria against a static reference, then add corresponding cells together into an eventual sum.
In English: If A2 = red and B2 = sunny and C2 = 20, D2 (+ all other values that passed this same logic test). Move to check next row. Else, move to check next row.
Since two of the rows (4 and 6) pass the logic test, the expected outcome would be 20
As a function: That's where you come in... Thanks in advance.
To the people saying SUMIFS - Yup! That's probably exactly what I'm looking for, but I said I'd update this to be clearer, so I am. I'm going to look into it a bit and try to understand how to implement it, then I'll mark this solved. Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site