SUMIF Query

  • Thread starter Thread starter John
  • Start date Start date
J

John

I want to add values in Column D together if the value in column B equates
to a reference in cell A1

I want basically to get monthly totals of values for each week.

I have entered the following formula but it returns a Zero value which is
not correct

=SUMIF(B7:B59,"=Report!B6",D7:D60)

B7 through B59 lists various calander months, =Report!B6 is a reference cell
that shos the current month, D7 through D60 is the values I want to add

Thanks
 
Hi
try
=SUMIF(B7:B59,"=" & Report!B6,D7:D59)
note: both range should eb of the same size. I changed the third
parameter of your example formula as well
 
This would also work:

=SUMIF(B7:B59,Report!B6,D7:D59)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Frank your definitely King of the Boards!

Thanks again
 
Back
Top