Sum with Multiple categories

Lakhi916

New Member
Joined
Aug 7, 2018
Messages
6
BudgetCategory Employee ID Employee Wages Wage Wages
Hrs Amount Hrs Amount Hrs Amount
DPP 25 Jon 5 500 5 400 5 600

I would like to sum all the amounts for employees that are in the DPP category. Can someone give me formula? I have multiple budget categories and need an easier way to SUM.

Thanks!
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
BudgetCategory Employee ID Employee Wages Wage Wages
Hrs Amount Hrs Amount Hrs Amount
DPP 25 Jon 5 500 5 400 5 600

I would like to sum all the amounts for employees that are in the DPP category. Can someone give me formula? I have multiple budget categories and need an easier way to SUM.
 
Upvote 0
Why did you repeat your question?
Did you try SUMIF?
The link I provided shows actual examples of how to do that.

You cannot post your data like that. It is unreadable.
There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
 
Upvote 0
If you are looking for a summary of ALL different categories, and don't want to create separate Excel formulas for each one, take a look at using Pivot Tables or Subtotals.

If you Google "creating pivot tables in Excel", you will find many different tutorials you can view to do this (including some YouTube videos).
You can do the same for Subtotals (Google "creating subtotals in Excel").
 
Upvote 0
is there a way for me to post a pic of my spreadsheet to see if you can give me a formula?
I posted that in reply number 4 above.

But did you even look at my link for SUMIF? It shows you exactly how to create that formula. It is very straightforward.
 
Upvote 0
I was hoping this thing would let me post a example photo so I could explain better....I am also trying to incorporate a vlookup along with sumifs. I know how to use those formulas together but not in this particular case.
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,280
Members
452,902
Latest member
Knuddeluff

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