Quote:
Originally Posted by Claus Busch
Hi,
Am Mon, 13 Oct 2014 20:54:07 +0200 schrieb Claus Busch:
=SUMIF(A1:A4,"0",B1:B4)
if there can be values < 0 in column B then try:
=SUMIFS(B1:B4,A1:A4,"0",B1:B4,"0")
or
=SUMPRODUCT(--(A1:A40),--(B1:B40),B1:B4)
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|
Does Excel give us the option to sum amounts in a column based on the amount being greater than 0, and if the cell is highlighted a certain color? For example, if cells A2 and A4 were highlighted, is there a way to add just those two cells from that column?