SumIf Question

[CARL]

Will the SUMIF work in the following scenario:

I have a date in B9 and A1. If the 2 dates are the same, I
would like the formula to sum the cells B2:B6.

I cannot seem to get the formula to sum coreectly.

Thank you in advance.

 

[Frank Kabel]

Hi
try
=IF(A1=B9,SUM(B2:B6),"")

 

[Peo Sjoblom]

One way

=(B1=A1)*SUM(B2:B6)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Peo Sjoblom]

Oops! Replace B1 with B9

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom