SUMIF

Hi Everyone,
I think this is a very basic question. I want to graph the total piece rate items completed (Daily Totals) for a drop-down selection of (Job Codes). I have the sheet up and running and know how to create a Dashboard with graphs etc but just need help with the formula.
Thanks in advance
Answers
-
Are you able to provide screenshots for context or more details?
-
Hi Paul, thanks for your offer and sorry for the delay in getting back to you. I can send screen shots or share you into an example, which would you prefer?
-
Screenshots should be a good start.
-
Hi Paul,
I have over 6000 rows of data in this sheet. It collects a tally of sheep shorn by individual shearers and hours worked by shed staff in a number of teams each day. There is a dropdown list of 'Job Codes' for different types of work done. All I am trying to do is get a formula to amass totals for the whole sheet of each Job Codes. I will then display that on a Dashboard, so we have a running total of all work done throughout the year. I have a mental block when it comes to formulars but find most functions to be very intuitive.
Thanks in advance for your help.
Kind Regards
Peter
-
If I understand correctly, you are going to want a SUMIFS.
=SUMIFS(Hours:Hours, [Job Codes]:[Job Codes], @cell = [Job Type]@row)
-
Hi Paul
I'm still struggling sorry.
The 'Daily Totals' column is where the data we want is, for each category in the 'Job Codes' column drop-down list. e.g. Shear Ewes/Adult 2/S - Total from the entire column
-
Hi @peter65516,
Amend Paul's formula slightly to use the required column:
=SUMIFS([Daily Totals]:[Daily Totals], [Job Codes]:[Job Codes], @cell = [Job Type]@row)
-
@peter65516 You would just need to adjust the first range to reference whatever column you want to sum the totals from.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!