Hi all,
I have sheet, A1 is name, B1 is amt and C is result. I want to sum of amt
who is late and ontime. and also wants name who is late or ontime. can it is
possible. please help me and tell me how is possible. I can show u example.

A1 B1 C1
Name amt Result
a 100 late
b 200 ontime
c 300 late
d 400 late
e 500 ontime
f 600 ontime
g 700 ontime
h 800 late

sum of late 1600 (a,c,d,h)---- name of late person
sum of ontime 2000 (b,e,f,g)---- name of ontime person

please help me
thanks
RKS