If or Vlookup function help

[Mohamed Sameer Kazi]

Hi Team,

just need help to find the intervals value if the calls received on given intervals for selected VQ

e.g
2019-08-04 07:00-07:15 - VQ_CC_AR_BOOKING_PRICE_INQ = 5 calls etc..

Intervals are in Cell B

how to get the value in cell C885 till N885 for all intervals till 2019-08-04 20:45-21:00

Really need you guys help

 

[vletm]

Mohamed Sameer Kazi
Interesting unknown term but ...
for cell C885 =SUMIFS($G$2:$G$878,$B$2:$B$878,$B885,$F$2:$F$878,C$884) and copy&paste as needs

 

[Mohamed Sameer Kazi]

Thank you so much for the assistance and help