countif question

[tf37]

Can I do something like this:
=COUNTIF(C2:C3004,"=DUTC*", B2:B3000, "<>ASG")
I am trying to count one column that it will equal DUTC, which works by itself, but when I try to count those that equal DUTC, but do not count if column B contains ASG
Is it possible, or am I going at it in the wrong direction.
Thanks gang,
Terry

 

[Haseeb Avarakkan]

Hello, Try,

If you have excel 2007 or later;

=COUNTIFS(B2:B3000,"<>ASG",C2:C3000,"DUTC*")

Excel 2003 or earlier;

=SUMPRODUCT(--(B2:B3000<>"ASG"),--(LEFT(C2:C3000,4)="DUTC"))

 

[tf37]

Am using Excel 2000 still.
You sample works, but I get the same results with:
countif(C2:C2000, "=DUTC*")
Both you sample & mine show a count of 225.
I would like to count those that =DUTC, but not if ASG in included in the column B
Thanks again

 

[scottylad2]

Can I do something like this:
=COUNTIF(C2:C3004,"=DUTC*", B2:B3000, "<>ASG")
I am trying to count one column that it will equal DUTC, which works by itself, but when I try to count those that equal DUTC, but do not count if column B contains ASG
Is it possible, or am I going at it in the wrong direction.
Thanks gang,
Terry

Countifs will only work if you have office 2007 or later, for earlier versions try

=SUMPRODUCT(--(ISNUMBER(SEARCH("DUTC*",C2:C3004))),--(B2:B3000<>"ASG"))