Sum If Formula with multiple criterias

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,280
Office Version
  1. 2013
Platform
  1. Windows
Good Day,
Please check below table that from E2 all the way down what will the proper formula supposed to be add to get correct results.
Many Thanks

JOB TITLESALARYJOB TITLETOT STAFFTOT STAFF EXPENCES
A6000A1166,000
B5000B1995,000
C3900C1039,000
D3800D1038,000
E3600E1554,000
F3300F1859,400
G2700G2259,400
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
=B2*D2
based on your example
but i suspect more to it , but no idea , if theres is something else needed from the post

Book7
ABCDEF
1JOB TITLESALARYJOB TITLETOT STAFFTOT STAFF EXPENCES
2A6000A1166,00066000
3B5000B1995,00095000
4C3900C1039,00039000
5D3800D1038,00038000
6E3600E1554,00054000
7F3300F1859,40059400
8G2700G2259,40059400
Sheet1
Cell Formulas
RangeFormula
F2:F8F2=B2*D2
 
Upvote 0

Forum statistics

Threads
1,216,083
Messages
6,128,718
Members
449,465
Latest member
TAKLAM

We've detected that you are using an adblocker.

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.
Go back
Back
Top