LinkBack URL
About LinkBacks
I would like to calculate and sum the netsales in one step with sumproduct ...
Gross Tax
500 4.5%
750 5.0%
1000 5.5%
e.g. 500*1/1.045 + 750*1/1.05 + 1000*1/1055
Or any alternative way?
Thanks for any help.
Andreas
I would like to calculate and sum the netsales in one step with sumproduct ...
Gross Tax
500 4.5%
750 5.0%
1000 5.5%
e.g. 500*1/1.045 + 750*1/1.05 + 1000*1/1055
Or any alternative way?
Thanks for any help.
Andreas
If I follow you well, and your data is in A2:B4 (row 1 is for headers) then netsales could be calculated as:
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
thanks Kaper,
Net Sales are in A2:A4, Tax Rates in B2:B4
And the calculation could be simplified by ... 500/(1+4.5%) + 750/(1+5.0% + 1000/(1+5.5%)
Andreas
Have you tried the above formula?
It does exactly 500/(1+4.5%) + 750/(1+5.0%) + 1000/(1+5.5%)
Perfect - thanks ...
One more question:
How can I additionally filter certain rows for this calculation, when I add an additional column C2:C4 with specific dates for those sales, and I would just like to see the sum for a specific date, or date-range, or month, or year?
Yes you can.
If the above is not enough refer to 5th bulletpoint under numbered rulse in https://www.excelforum.com/forum-rul...rum-rules.html
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks