SumIf Help

[parteegolfer]

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:G400>1 then sum D7400)

Can someone help with the correct formula!

Thanks

 

[Dav]

try

sumproduct((C7:C400="")*(G7:G400>1)*(D7400))

Regards

Dav