Forum Discussion

sudharsanan jana's avatar
sudharsanan jana
Copper Contributor
Oct 12, 2017

FORMULA FOR AUTO CALCULATION

I am having a doubt in calculation for example if the percentage value is 6% on different fields on a column i need to calculate the total invoice value of the six percentage automatically it should be calculate according the percentages

 
FOR EXAMPLE: All the 6% on the list invoice value to automatically added to total of invoice value 6%
same to other percentage value also.
 
If D column - percentage and B column - total inv value
B2= 150000 AND D2 = 6%
B3=176000 AND D3=9%
B4-225000 AND D4=6%
B5-270000 AND D5- 9%
In this all 6% invoice values should be automatically calculated and totalled.
please help
 

Excel Desktop
Formulas & Functions

1 Reply

  • julie dall's avatar
    julie dall
    Copper Contributor
    Oct 16, 2017

    Hi

     

    From what I understand, you want to total all your invoices based on the percentage in column D

     

    Using your example, enter the following

    C7 - 6%

    C8 - 9%

    Then in D7 type =SUMIF($D$2:$D$5,C7,$B$2:$B$5)

    Fill down for D8

     

    This will sum all of the invoices in column B, where the value in column D equals the value in C7 and C8 respectively.

     

    Hope this helps.
    Cheers

    JulieD