Formula calculating mınutes

[asyamonique]

=IF(TEXT(SUMIF($A$21:$A$27,A31,B21:AF21)/60/24,"[h]\h\r\s m\m\i\n")="0hrs 0min","",TEXT(SUMIF($A$21:$A$27,A31,B21:AF21)/60/24,"[h]\h\r\s m\m\i\n"))

Hi,
Please help me with above formula,
Why it is calculating only B21 values ınstead total of B21:AF21 values?
Many Thanks

 

[Tetra201]

Your criteria range is $A$21:$A$27.
Your summation range starts at B21.
Therefore, range B21:B27 will be used for summation, and not B21:AF21.