Multiplying by a % at the end of a formula string.

[MrLunchbox]

Good morning folks!

I am having issue adding in a ending to a formula to multiple by a percentage. The formula is pulling data from a different sheet to bring an ending number to a main sheet. I am taking a SUMIF of cells and looking for any cell that container (A) in it. If that cell does contain (A) in it I am taking the value of the adjacent cell and coming up with a total in $ amount. I am then taking a COUNTIF of the same original cells that contain (A) in them and multiplying by*20 for a second dollar figure. I am subtracting that dollar figure from the original amount from the SUMIF function to come up with a final number.

I now want to take that number and multiply it by 5%. I am having issue doing so. I have tried *(1-5%) at the end of the string but it is not working.

Here is my formula as it stands now:

=SUMIF('Oil Usage'!B3:B200,"*(A)*",'Oil Usage'C3:C200)-COUNTIF('Oil Usage'B3:B200,"*(A)*")*20

I appreciate any help and guidance. Please forgive me if this seems confusing and mashed together. I am not completely knowledgeable in the depths of excel.


Happy new year
Lunchie

 

[Joe4]

Welcome to the Board!

If I undersrtand you correctly, you should just be able to put your whole current formula in parentheses, and multiply by 5%, i.e.

=([COLOR=#333333]SUMIF('Oil Usage'!B3:B200,"*(A)*",'Oil Usage'C3:C200)-COUNTIF('Oil Usage'B3:B200,"*(A)*")*20)*5%[/COLOR]

 

[MrLunchbox]

Welcome to the Board!

If I undersrtand you correctly, you should just be able to put your whole current formula in parentheses, and multiply by 5%, i.e.

=([COLOR=#333333]SUMIF('Oil Usage'!B3:B200,"*(A)*",'Oil Usage'C3:C200)-COUNTIF('Oil Usage'B3:B200,"*(A)*")*20)*5%[/COLOR]

Thank you sir! I am smacking myself for this one lol. I was putting the parentheses before the COUNTIF rather than the beginning of the whole formula.

Thank you so much for your time!

 

[Joe4]

No problem! It is easy to sometimes lose sight of the forest for the trees! We all have been there.

Glad I was able to help.