#VALUE! error in SUMIF formula

Topic

New Reply

I am trying to create a SUMIF formula using nonadjacent ranges and I am getting a #VALUE! error.
=SUMIF((A3,C3,E3,G3,I3),””””,(A2,C2,E2,G2,I2))

What is wrong? the formula works with adjacent ranges in the form A1:A5. I am trying to add a row of numbers if the cell in the reference row is not empty.

Reply | Quote

Replies

If one of the cells contains text (eg blank space), then the sum() would fail because it only adds numbers.
But also, SUMIF() seems to like a coherent range (A3:I3)rather than the intermediate ones
Ruth

Reply | Quote