Using weekday formula as part of AVERAGEIFS

[Sudhaji]

I am trying to calculate the total hours for weekend and weekday separately and am having trouble calculating the weekend hours. Please look at columns BQ and BR.

Thank you to anybody who can help me please!
Sudha

 

[Nebu]

Hi:

I have changed your WKEND HRS formula to
=SUM(SUMIFS($A$6:$BK$6,$A$4:$BK$4,{7,1}))
and your WKEND AVG formula to
=AVERAGE(AVERAGEIFS(A6:BK6,$A$4:$BK$4,{7,1}))

Thanks

 

[NARAYANK991]

Hi ,

If you do not mind using array formulae , the following , which need to be entered using CTRL SHIFT ENTER , will also work :

=SUM(SUMIFS(A6:BK6,A4:BK4,$BL$1:$BM$1))

=AVERAGE(AVERAGEIFS(A6:BK6,A4:BK4,$BL$1:$BM$1))

Narayan

 

[Sudhaji]

Hi:

I have changed your WKEND HRS formula to
=SUM(SUMIFS($A$6:$BK$6,$A$4:$BK$4,{7,1}))
and your WKEND AVG formula to
=AVERAGE(AVERAGEIFS(A6:BK6,$A$4:$BK$4,{7,1}))

Thanks

Thank you so very much for your help.