I'm trying to sum columns/rows with multiple criteria using sumifs and sumproduct, but get value errors. My data table looks like this:
<tbody>
1000
2000
3000
Total
1000
#
Emp#
Salaries
Bonuses
Pension
Total
Salaries
Ben A
121
1568.98
500.00
(29.65)
2039.33
150.00
0.00
</tbody>
My...
Hi all,
I am an excel noob new to this forum so please forgive me if I have done something wrong.
There are some activities at work which are seriously bugging me as I have to manually calculate bonuses for certain contracts which takes forever, I know there is a quicker way to do this but I...
I'm using Excel 2010.
I'm working on sales commissions & bonuses. The commission part is easy – just multiply the cell w/ the sales number times the commission rate (as an absolute reference).
I'm stuck on our sliding scale for bonuses.
For example:
IF sales >=120,000, bonus =2.5%
IF sales...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.