Help with SUM(IF(FREQUENCY(IF.. with more than 1 lookup frequency!

[MichaelBuechler]

Hello,

If got an issue while summing a value with two parameters using the SUM(IF(FREQUENCY(IF... formula and would like to add an additional parameter to it.

View attachment 41590

See excel file for data source. Does anybody has a clean solution?

Help much appreciated!!!
Michael

 

[NARAYANK991]

Hi ,

Try this :

=SUM(IF(TimeReporting!$E$2:$E$118 = $B3, IF(TimeReporting!$K$2:$K$118 = "x", 1/COUNTIFS(TimeReporting!$E$2:$E$118, $B3, TimeReporting!$K$2:$K$118, "x", TimeReporting!$D$2:$D$118, TimeReporting!$D$2:$D$118))))

This is an array formula , to be entered using CTRL SHIFT ENTER.

Narayan

 

[MichaelBuechler]

Hi ,

Try this :

=SUM(IF(TimeReporting!$E$2:$E$118 = $B3, IF(TimeReporting!$K$2:$K$118 = "x", 1/COUNTIFS(TimeReporting!$E$2:$E$118, $B3, TimeReporting!$K$2:$K$118, "x", TimeReporting!$D$2:$D$118, TimeReporting!$D$2:$D$118))))

This is an array formula , to be entered using CTRL SHIFT ENTER.

Narayan

Awesome!!! Works just fine - save of today Thank YOU very much appreciated!