Sum if function

psrs0810

Well-known Member
Joined
Apr 14, 2009
Messages
1,109
I have a file that contains hours by department by job code down to the earnings code level. What I am trying to do is sum up in separate columns: worked hours, paid hours and Overtime hours.</SPAN>
I have a separate table that tells me which earnings codes counts towards Worked/Paid/OT.</SPAN>
So if I am trying to sum worked hours I need to go to the earnings code file column D, if that is “True” go over to the respective row take that number and find it on the main sheet column F and sum column I</SPAN>

This is what i have:
=SUMIFS(I:I,'[Earnings Codes.xlsx]Sheet1'!$D:$D,"TRUE",F:F,'[Earnings Codes.xlsx]Sheet1'!$B:$B)</SPAN>
but the number I am getting, is no where near close to what it should be.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

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