Forum Discussion
Looking for Excel Function Advise
I need some guidance on what function to use to sum of a data range for criteria contained in another data range. Down in Cell E78, I would like to count the number of adults attending a wedding ...
You're right that COUNTIF isn't the right function. I want to encourage you to learn to play around, guess around, use your intuition a bit. In this case, you want to add things up, right, not just count whether there's an entry in a column. Add things up, hmmm. Turns out that there's a SUMIF function, which works much like COUNTIF but adds up entries in one column based on criteria met in another.
Do you have access to any Excel resources? If not, here's a link to the SUMIF function as described in ExcelJet.Net, a resource that I recommend.