Hello,
In the following example below I am trying to use a SUMIFS/MAX formula to get the total sum of a event minus the allowed amount of time for a event. When i try to use the formula below i get a sum of 0:00:00 instead of the actual value. Should i use a different formula completely or does the formula below just need a few tweaks
=SUMIFS($M$12:$M$300,$J$10:$J$300,B$12,$A$13:$A$85,A13)*MAX(0,C$2-B13)
https://ibb.co/xSmKKZ8
In the following example below I am trying to use a SUMIFS/MAX formula to get the total sum of a event minus the allowed amount of time for a event. When i try to use the formula below i get a sum of 0:00:00 instead of the actual value. Should i use a different formula completely or does the formula below just need a few tweaks
=SUMIFS($M$12:$M$300,$J$10:$J$300,B$12,$A$13:$A$85,A13)*MAX(0,C$2-B13)