SUMIF Problem

[andyp161]

Duane, thanks!!

The formula does exactly as I had requested, but I have a problem. I
column B, I have the following formula
=IF(DAYS360(G2,J2)<1,"",DAYS360(G2,J2)). Therefore, when I use you
formula #VALUE! is returned. I think it is because I'm replacing al
values <1 in column B with "" - but this is something I want t
maintain. Is there any way around this?

Many thank

 

[Dave Peterson]

maybe:

=SUMPRODUCT((A1:A30 = "Andrew Penfold")*ISNUMBER(B1:B30)*(B1:B30>0)*(C1:C30))

 

[duane]

could you insert a new column like if(b2="",0, b2) and use new column i
my sumif instead of column b