Sum cells in a row based on two conditions, one of which also has a condition.

Hi!

I'm having a hard time with this one:

I have a document, on the leftmost column, is a list of 200 employees.
The rest of the columns are divided in groups of 4 (Hours, Level of Work (1-5), Rate, Pay), each group separated by date.
So it looks something like this:
A B C D E F G H I K L M N O P Q R
1 | | | | Date 1 | Date 2 | Date 3 | Total Level 1 Work
2 |Emp. Numer | Emp. Name | Position | Hours | Lvl | Rate | Pay | Hours | Lvl | Rate | Pay | Hours | Lvl | Rate | Pay | Hours | Pay
3 | 100 | John | Concierge | 2 | 1 | 15 | 30 |

I need to calculate How many hours and how much was payed per level of work, during a two month period.
So I need a formula that Sums the hours in a row, when the level of work for a date is 1, or 2, or, or, 4, or 5.

I was trying this formula:
=SUMIF(D2:P2,(IF(D2:P2="Area"&D3:P3=1,"hours")),D3:P3)

Thanks for your help!
Screenshot (1).png

Hi, welcome to the forum

Take a look at the sumifS() function instead

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Thank you for the notes!

I tried using a SUMIF, but couldn't find a way to make it work.
It's kinda like SUMIF, but one of the conditions has a condition.
It's kinda hard for me to explain, I'm a little blocked.

The Total Level 1 Work Hours cell for each employee should sum the hours, only if the cell right next to it (Level) has a number 1 in it.
I'm currently doing it manually "=SUMIF(LevelCell#1,1,HoursCell#1)+SUMIF(LevelCell#2,1,HoursCell#2)..."
But it's going to take me a loooooong time Example.xlsx

I'm attaching a worksheet as suggested.

Thank you again for your help!

Sumifs is definitely a solid way of doing this, however the layout of your sheet is adding to the headache you are having. Once you set it up once, it will not be so bad... but I would recommend changing how you are logging this data - (This is manual entry right?)

IF so... see attached for recommendation on layout and use -

Example_Efficient.xlsx

Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version.