SUMIF argument w/ single text criteria BUT with added tax for specific cells

Hi there!

First time user with limited excel formula and syntax knowledge working with Excel 2007.

I have a budget workbook with several sheets from which I would like to pull numbers to summarize on one sheet.

I need help writing a formula to:

(a) add a range of numbers (e6:e41) with text criteria (d5:d41) then add 5% tax to that total

AND

(b) add numbers (e49:e84) with text criteria (d49:84) without tax.

Using the Microsoft knowledge base this is as far as I got since I received syntax errors when I tried to add to the formula the second argument string.

=SUMIF('Bath Fixtures'!$D$6:$D$41,"*kitchen*",'Bath Fixtures'!$e$6:$e$41)*1.05

I appreciate any help!

-Gianni

I checked your formula and it seems fine. What seems to be the problem?

Not sure if you are searching for the same thing but either way, this would be the formula

=SUMIF('Bath Fixtures'!$D$6:$D$41,"*kitchen*",'Bath Fixtures'!$e$6:$e$41)*1.05+SUMIF('Bath Fixtures'!$D$49:$D$84,"*kitchen*",'Bath Fixtures'!$e$49:$e$84)