SUMIF

peter65516

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

Paul Newcome

Are you able to provide screenshots for context or more details?

peter65516

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?

Paul Newcome

Screenshots should be a good start.

peter65516

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

Paul Newcome

If I understand correctly, you are going to want a SUMIFS.

=SUMIFS(Hours:Hours, [Job Codes]:[Job Codes], @cell = [Job Type]@row)

peter65516

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

Nick Korna

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)

Paul Newcome

@peter65516 You would just need to adjust the first range to reference whatever column you want to sum the totals from.