Hey Guys,
So odes anyone know how to use the sum if function for a range? I'm trying to evaluate for a yes in coumn c (c2:c102) and add the values based on yes in columns I through K (i2:k102).
The problem is that it only seems to sum the values in column i.
I know that i could go ahead and do a seperate sumif for each column, but id rather not.
Any thoughts?
Thanks,
Ritz
Bookmarks