Sum range where column heading contains specific text

[heytherejem]

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

[AliGW]

Why are you using the wildcards?

What do you get with this?

=SUMIF(H$1:BC$1,"Forecast Volume",H69:BC69)+SUMIF(H$1:BC$1,"Forecast Expense",H69:BC69)

=SUMIF(range,criterion,sum_range)

[heytherejem]

I need the Wildcard as there is a date for each expense.

Your solution solves it if I include the wildcard so

=SUMIF(H$1:BC$1,"*Forecast Volume",H69:BC69)

Thanks!

[AliGW]

Yes - you just needed to get the correct order for the statements.