Countifs equiv in 2003

D

Dan

I am using a countifs based formula successfully but need to save this in a
2003 format for those who do not have 2007. Countifs is not supported in
2003. I am challenged finding a similar solution.

=COUNTIFS(Data3!$A:$A,$A22,Data3!$C:$C,"=wb*")

Any suggestions? Your help is greatly appreciated.

Thanks!
 
T

T. Valko

=wb*

Is that the *literal* string that you're looking for or does that mean wb
wildcard?

I don't know what Countifs is doing (don't have Excel 2007):

=COUNTIF(..........)+COUNTIF(..........)

Or

=SUMPRODUCT(--(............),--(............))

Biff
 
D

Dan

The "wb*" is any record that begins with "wb". Countifs allows for multiple
criteria that I understand sumproduct can accomplish as well. I do not
understand the syntaz (--(. If you took the literal formula and placed it in
a sumproduct format what would it look like.

COUNTIFS(Data2!$A:$A(range 1),A13(criteria 1),Data2!$C:$C(range
2),"=wb*"(criteria 2))
 
T

T. Valko

Ok.....

Since you're making this workable for Excel 2003 you *can't* use entire
columns as range references:

=SUMPRODUCT(--(Data2!$A1:$A100=A13),--(LEFT(Data2!$C1:$C100,2)="wb"))

Biff
 
D

Dan

Thank you!

T. Valko said:
Ok.....

Since you're making this workable for Excel 2003 you *can't* use entire
columns as range references:

=SUMPRODUCT(--(Data2!$A1:$A100=A13),--(LEFT(Data2!$C1:$C100,2)="wb"))

Biff
Click to expand...
 
Top