SumIf Question

  • Thread starter Thread starter CARL
  • Start date Start date
C

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.
 
One way

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

--


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

Regards,

Peo Sjoblom
 
Oops! Replace B1 with B9

--


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

Regards,

Peo Sjoblom
 
Back
Top