[Solved] Countifs -Need to populate counts in summary

[MISAJ]

Hello,

i am looking for some counts of TAT hours to populate in summary and unable to identify why not showing.

in attached excel (TN TSR TAT column G) is # hours orders completed and same should update day wise in summary from 0 to 4hrs till more than 24hrs

 

[shamimarita]

Hello Miraj,

The hours list for the "TAT summary" sheet and the "TN TSR TAT" sheet were different. That's why COUNTIF is returning 0.

I updated the hours range in the "TAT summary" sheet following the "TN TSR TAT" sheet.


Download the Excel File: