sumif with detail
 

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

sumif with detail
 

In cell D1 enter:
=SUMPRODUCT((B2:B1000),--(C2:C1000="ontime"))
In cell D2 enter:
=SUMPRODUCT((B2:B1000),--(C2:C1000="late"))


To get the names is easier.

Click on C1 and pull-down:

Data Filter AutoFilter
--
Gary''s Student - gsnu200779


"RKS" wrote:

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

sumif with detail
 

Take a look how to create Pivot table in Help menu


"RKS" wrote:

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

sumif with detail
 

Thanks Gary for giving responce. formula is right but my problem still. I
need name also who is late and ontime then my problem is solve. dont wants
use autofilter which u recomended, after finished this then i can protect
sheet and send user to enter data in some cell. so please help me and tell me
how i can get name in one line like this 1600 (a,c,d,h)
thaks for reply
rks


"Gary''s Student" wrote:

In cell D1 enter:
=SUMPRODUCT((B2:B1000),--(C2:C1000="ontime"))
In cell D2 enter:
=SUMPRODUCT((B2:B1000),--(C2:C1000="late"))


To get the names is easier.

Click on C1 and pull-down:

Data Filter AutoFilter
--
Gary''s Student - gsnu200779


"RKS" wrote:

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