sumif

M

Mark

Can I sumif on multiple columns instead of one column? It
works with on column, but when I expand it to a group of
columns, it doesn't work.

I need it to evaluate a range and sum for each "Name"...

Thanks...
 
N

Nikki

If I am understanding you correctly, would you be able to use a formula like
this?=SUMIF(A1:A25,"john",B1:B25)+SUMIF(D1:D25,"john",E1:E25)
 
Top