sumif function

[Guest]

Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)="AD")
somethin like this?

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D110,2)="AD"),C1:C10)

For an explanation of the "--", see

http://www.mcgimpsey.com/excel/doubleneg.html

 

[Guest]

Try
=sumproduct(--(a1:a10="hello"),--(left(d1:d10,2)="AD"),c1:c10)

[the --( is to convert a logical true false to 1,0]

 

[Guest]

Use Sumproduct instead.
=Sumproduct(--(A1:A10="hello"),--(left(d1:d10,2)="AD"),(C1:C10))
Alok Joshi

 

[Guest]

No, but you can use SUMPRODUCT

=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D110,2)="AD"),C1:C10)


Regards,

Peo Sjoblom