Nov 15 2021 05:47 AM
Hello Excel forum,
I am looking for a maybe quite complex formula (or I think too complex :) ) and hope someone can help me.
Can you tell me how to make a sum of values depending on several criteria? So the formula should form the sum of the Overtimes as well as the sum of the Vacation for the several Workers below.
I tried with "lookup", "index", "countif", "sumif", etc...but I assume to be a combination of formula.
Hoping you can help me to fill the yellow fields in the attached Excel file.
Thank you in advance.
Greetings
Tobias
Nov 15 2021 06:04 AM
SolutionIn B37:
=SUMPRODUCT(($A$2:$O$32=B$36)*($A$1:$O$1=$A37))
Fill down, then to the right (or vice versa).
See the attached version.
Nov 15 2021 08:46 AM
Nov 15 2021 06:04 AM
SolutionIn B37:
=SUMPRODUCT(($A$2:$O$32=B$36)*($A$1:$O$1=$A37))
Fill down, then to the right (or vice versa).
See the attached version.