Doubt in excel formula

  • Thread starter Thread starter saraskandan
  • Start date Start date
S

saraskandan

I need to know how issues have been resolved in given time from morning
till evening in a different sheet

Sheet 1

08:00 - 08:30 - case 1
case 2
case 3
08:30 - 9:00 - case 1
09:00 - 09:30 - Case 1
Case 2
Case 3
Case 4
Case 5
similarly till evening around 200 cases

Sheet 2 - I should show

08:00 - 08:30 - x
08:30 - 09:00 - X
09:00 - 09:30 - x

How do I do this using lookup formulae or is there any other formulae
 
Exactly how are your columns laid out?
08:00 - 08:30 - case 1
08:00 - 08:30 case 1
08:00 08:30 case 1
 
My Columns are following manner

I have these on a daily basis in excel

Row 1Column A Column B,C,D,E,F........
Row 2 Time 1,2,3,4..............
Row 3 08:00 - 08:30 2,3,4......
Row 4 08:30 - 09:00 4,5,6,7....
Row5 ...................
Row 6 ...............
 
Actually you might like this better
=SUMPRODUCT((a3:a33="08:00 - 08:30")*b3:k33)
or even
=SUM(OFFSET(a3,,,,15))
 
Guys...

Sorry to interupt... my logic was in sheet 1 i have data in following
manner

I have different timing and each timing would have several inputs. I
need these input to be consolidated in Sheet 2 with their respective
timing

for exampl,

if the timing is 08:00 - 08:30 in 1st column and the inputs such as
case 1, case 2, case 3, case 4 case 5 in 2nd column in different rows.

Timing Total Cases
08:00 - 08:30 5
 
use the sumproduct formula I gave you with the sheet in front

==SUMPRODUCT((a3:a33="08:00 - 08:30")*b3:k33)
SUMPRODUCT((sheet1!a3:a33="08:00 - 08:30")*sheet1!b3:k33)
 
Its not gving me the count. the formulae is not giving me the number of
cases done in a given time.
 
Back
Top