Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif function
Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)= "AD")
somethin like this? |
#2
|
|||
|
|||
One way:
=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D1:D10,2)="AD"),C1:C10) For an explanation of the "--", see http://www.mcgimpsey.com/excel/doubleneg.html In article , "Fred Lavallee" <Fred wrote: Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)= "AD") somethin like this? |
#3
|
|||
|
|||
Try
=sumproduct(--(a1:a10="hello"),--(left(d1:d10,2)="AD"),c1:c10) [the --( is to convert a logical true false to 1,0] "Fred Lavallee" wrote: Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)= "AD") somethin like this? |
#4
|
|||
|
|||
Use Sumproduct instead.
=Sumproduct(--(A1:A10="hello"),--(left(d1:d10,2)="AD"),(C1:C10)) Alok Joshi "Fred Lavallee" wrote: Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)= "AD") somethin like this? |
#5
|
|||
|
|||
No, but you can use SUMPRODUCT
=SUMPRODUCT(--(A1:A10="hello"),--(LEFT(D1:D10,2)="AD"),C1:C10) Regards, Peo Sjoblom "Fred Lavallee" wrote: Is it possible to =sumif(and(a1:a10,"hello",c1:c10),(left(d1:d10,2)= "AD") somethin like this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions |