Originally Posted by Claus Busch

hi,

Am Mon, 13 Oct 2014 19:19:32 +0100 schrieb redlegend:

A1=0
B1=40
A2=10
B2=15
A3=30
B3=20
A4=10
B4=0

a 0 in column B does NOT change the sum and so it must not be ignored.
Try:
=SUMIF(A1:A4,"0",B1:B4)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional