F
Fred Lavallee
Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)="AD")
somethin like this?
somethin like this?
J
JE McGimpsey
One way:
=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D1
10,2)="AD"),C1:C10)
For an explanation of the "--", see
http://www.mcgimpsey.com/excel/doubleneg.html
=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D1
10,2)="AD"),C1:C10)For an explanation of the "--", see
http://www.mcgimpsey.com/excel/doubleneg.html
B
bj
Try
=sumproduct(--(a1:a10="hello"),--(left(d1:d10,2)="AD"),c1:c10)
[the --( is to convert a logical true false to 1,0]
=sumproduct(--(a1:a10="hello"),--(left(d1:d10,2)="AD"),c1:c10)
[the --( is to convert a logical true false to 1,0]
A
Alok
Use Sumproduct instead.
=Sumproduct(--(A1:A10="hello"),--(left(d1:d10,2)="AD"),(C1:C10))
Alok Joshi
=Sumproduct(--(A1:A10="hello"),--(left(d1:d10,2)="AD"),(C1:C10))
Alok Joshi
P
Peo Sjoblom
No, but you can use SUMPRODUCT
=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D110,2)="AD"),C1:C10)
Regards,
Peo Sjoblom
=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D1
10,2)="AD"),C1:C10)Regards,
Peo Sjoblom