Hi Guys!
Basically I have a table like this:
The Names are filtered from another table and are dynamic.
I am trying to sum the values based on two criteria ("Duration" and "Day of week"), like this:
=SUMIFS($B5:$E5,$B$2:$E$2,G$2,$B$3:$E$3,G$3)
This gives a correct result, but I want the formula to dynamically update, based on the dynamic formula that contains the names. So I tried this:
=IF(A5#<>0,SUMIFS($B5:$E5,$B$2:$E$2,G$2,$B$3:$E$3,G$3),0)
This goes way down the table, but it always returns the sum of the first row.
Is anyone aware of a solution to this? It doesn't have to be this way but I want it to update the rows automatically and of course, return a correct solution.
Basically I have a table like this:
/// | A | B | C | D | E | F | G | H | I | J |
1 | Date | 1-Jan-22 | 2-Jan-22 | 3-Jan-22 | 4-Jan-22 | … | ||||
2 | Type | Duration | Duration | Duration | Duration | … | Duration | Duration | Duration | Duration |
3 | Day of week | 7 | 1 | 2 | 3 | … | 7 | 1 | 2 | 3 |
4 | Name | |||||||||
5 | Joshua | 8 | 0 | 8 | 8 | … | ??? | ??? | ??? | ??? |
6 | Jannet | 8 | 8 | 0 | 8 | … | ||||
7 | James | 8 | 8 | 8 | 0 | … | ||||
8 | Jack | 0 | 8 | 8 | 8 | … | ||||
9 | … | … | … | … | … | … |
The Names are filtered from another table and are dynamic.
I am trying to sum the values based on two criteria ("Duration" and "Day of week"), like this:
=SUMIFS($B5:$E5,$B$2:$E$2,G$2,$B$3:$E$3,G$3)
This gives a correct result, but I want the formula to dynamically update, based on the dynamic formula that contains the names. So I tried this:
=IF(A5#<>0,SUMIFS($B5:$E5,$B$2:$E$2,G$2,$B$3:$E$3,G$3),0)
This goes way down the table, but it always returns the sum of the first row.
Is anyone aware of a solution to this? It doesn't have to be this way but I want it to update the rows automatically and of course, return a correct solution.