I am looking to use the and command along with SumIf command to check
the conditions of two columns. If the two columns are true sum up the
columns that are true.


Example: SumIf(And(C7:C400="",G7:G4001 then sum D7:D400)

Can someone help with the correct formula!

Thanks


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=535546

try

sumproduct((C7:C400="")*(G7:G4001)*(D7:D400))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=535546