Ubuntu
openoffice.org package

SUMIF Empty Cell Treatment - Difference from MS Excel

Asked by Brad Payne

Assume the following spreadsheet entries...

Col A Col B
1 6
2
4 9
5

I want to sum all the numbers in Col A where there are no numbers in Col B on the same row.
The formula below returns 0 rather than 7 (ie 2+5) as it does in MS Excel - why?

=SUMIF(B1:B4,"",A1:A4)

I'd really appreciate any help on resolving this - I use this functional structure in many of my spreadsheets.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Fabio (fabio-mbnet) said : 		#1

Hi

Use this function: =SUMPRODUCT(b1:b4="";a1:a4)

Revision history for this message
Brad Payne (bradley-payne) said : 		#2

Thank you, that works fine in OpenOffice but unfortunately this equation isn't compatible with MS Excel.

Can you help with this problem?

Provide an answer of your own, or ask Brad Payne for more information if necessary.

To post a message you must log in.