SUMIF on filtered list

[NS4Excel]

I need to sum a row of data if another row shows Cap. The SUMIF formula works for that but now I need to sum the data if the list is filtered.
Col A contains the category of cost. Col B says if it is Cap or Exp. Col C-N shows the monthly totals for each. I need a formula at the top in row 1 that will sum the data in rows 2-50 based on the filters applied. Can anyone help me?
Thanks.

[FDibbins]

You may be able to use =subtotal(109,range), but that wont sum based on criteria.

Try a sumifS(), to include the filter criteria?

Maybe upload a sample WB?

[NS4Excel]

Attached is a sample file. You will see the first 3 columns can be filtered depending on need. Then I'd like the first two rows of totals to change based on the filters in columns A-C. Thanks.

[Tony Valko]

Try this...

Entered in D1:

=SUMPRODUCT(SUBTOTAL(9,OFFSET(D$4,ROW(D$4:D$19)-ROW(D$4),0)),--($C$4:$C$19=$C1))

Copy down to D2 then across as needed.

[NS4Excel]

WooHoo! Thank you so much!!! It works perfectly.

[Tony Valko]

You're welcome. Thanks for the feedback!

[JOHNROTHSCHILD]

You rock Tony! Thanks.