SUMIF with condition empty cells

[redwin]

I am trying to add data when a series of conditions are met. It is valid for
one of the cells tested in the SUMIF to be empty and the sum should still be
done. However this does not happen unless I make the cells have some value.
This could be done with a real character including a space or even if I make
the cell equal to another cell which is itself empty!?

(I have the same problem with the SUMIFS statement)

A B
1 2 5
2 7
3 2 5
4 1 5
5

Cell A2 has no contents, they have been deleted
Cell B5 contains the formulae =SUMIF(A1:A4,A5,B1:B4)


If cell A5 contains 1 the formulae gives 5 in cell B5
If cell A5 contains 2 the formulae gives 10 in cell B5
If cell A5 is empty (contents deleted) the formulae gives nothing in cell B5

If cell A2 has the value =E3 where E3 is simply a blank cell then
If cell A5 is empty (contents deleted) the formulae gives 7 in cell B5

How can I get the sum to be done even if a cell is empty?

 

[Bob Greenblatt]

I am trying to add data when a series of conditions are met. It is valid for
one of the cells tested in the SUMIF to be empty and the sum should still be
done. However this does not happen unless I make the cells have some value.
This could be done with a real character including a space or even if I make
the cell equal to another cell which is itself empty!?

(I have the same problem with the SUMIFS statement)

A B
1 2 5
2 7
3 2 5
4 1 5
5

Cell A2 has no contents, they have been deleted
Cell B5 contains the formulae =SUMIF(A1:A4,A5,B1:B4)


If cell A5 contains 1 the formulae gives 5 in cell B5
If cell A5 contains 2 the formulae gives 10 in cell B5
If cell A5 is empty (contents deleted) the formulae gives nothing in cell B5

If cell A2 has the value =E3 where E3 is simply a blank cell then
If cell A5 is empty (contents deleted) the formulae gives 7 in cell B5

How can I get the sum to be done even if a cell is empty?

Change the formula to:
=SUMIF(A1:A4,"="&A5,B1:B4)

 

[redwin]

Absolutely brilliant
Thank you very much