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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Columns in Sum Range using SUMIFS 1
SUMIF with criteria "<>" & "=" 4
How do I assign "Apple" to a cell reference in this evaluate code? 2
sumif issues 1
SumIf equation question 6
SUMIFS, one criteria range, multiple criteria 2
VLOOKUP or SUMIF for Multiple Criteria 2
Combine Sumifs with Subtotal 0

Top