Forum Discussion
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 sho...
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