SUM function questions

[AdiBosza]

G'day All - and thank you in advance for any help.

I'm stuck putting together a formula, which is supposed to sum particular numbers from a column, based on 3 conditions.
It's a table to track on-call hours and my goal with the formula is to count the hours into monthly summary, based on the date indication and also whether the on-call duty happened on a weekend/holiday.

All data is being entered manually by the reporting individual
Column 1 is the date
Column 2 is the name
Column 3 are the hours on duty (20% compensation, no matter whether weekday/weekend/holiday) - I was able to do this with a SUMIF, see H3, H8, etc.
Column 4 are the hours where action has been taken during duty (150% compensation if on weekday, so no holiday/weekend indicator is yes)
Column 5 is the indicator of weekend/holiday (200% compensation is on holiday/weekend, so any of those indicators are yes)

I wasn't able to solve the SUM of column 4. I started based on the same method as by column 3, so checking whether date is within a month, but then I wasn't able to take the column 5 indicator into consideration from the whole column, only for a single cell.

I attached the sheet, marked red the cells where I would like to have the sums for active hours 150% and 200% depending on the holiday/weekend indicator, and again, really appreciate any help.

[AliGW]

Welcome to the forum.

If this is a GoogleSheets query, it's in the wrong place. Please confirm and I'll move it for you.

[AliGW]

See if this gives you a leg-up:

=SUMIFS(D:D,A:A,">="&2/1/2024,E:E,"no")

[AdiBosza]

Hi Ali,

it is indeed a google sheet query, my bad for posting the wrong place.

Thank you!

[AliGW]

I'll move it. See post #3 - it may work in GoogleSheets - try it. You should be able to adapt it to other requirements.

[AdiBosza]

And this indeed helped - w.o.w.! Bless you for your quick response, this can be marked as [SOLVED]! Have a great day!

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[AliGW]

If the date is in a cell (e.g. F1):

=SUMIFS(D:D,A:A,">="&F1,E:E,"no")

See post #7 telling you how to sign off the thread.