Hi all,

I'm trying to do a SUMIF, add up a range if the column heading contains 'Forecast Volume'
The range is H1:BC69 with row 1 being the column heading.
The column heading can be Forecast Expense or Forecast Volume for each month of the year.

I am summing the Forecast Volume only at the end of the table. Instead of doing = H1+J1+L1 etc I want to do a SUMIF which looks at if the volume contains 'Forecast Volume' and only adds those cells.

I tried the below code but it's calculating the range at zero.

=SUMIF(H69:BC69,"**Forecast Volume",H1:BC1)

Help!

Thanks,
Jemma