|
|
|
date: Mon, 12 Mar 2007 20:27:00 -0700,
group: microsoft.public.excel.misc
back
Re: Countifs equiv in 2003
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
"Dan" wrote in message
news:5264A442-8710-4D81-81CD-F7CD3FD0B8EA@microsoft.com...
> 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. Valko" wrote:
>
>> =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
>>
>> "Dan" wrote in message
>> news:0C313761-70F8-4D29-8DE2-1BF9F8FF585F@microsoft.com...
>> >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!
>>
>>
>>
date: Tue, 13 Mar 2007 00:52:32 -0400
author: T. Valko
Re: Countifs equiv in 2003
Thank you!
"T. Valko" wrote:
> 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
>
> "Dan" wrote in message
> news:5264A442-8710-4D81-81CD-F7CD3FD0B8EA@microsoft.com...
> > 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. Valko" wrote:
> >
> >> =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
> >>
> >> "Dan" wrote in message
> >> news:0C313761-70F8-4D29-8DE2-1BF9F8FF585F@microsoft.com...
> >> >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!
> >>
> >>
> >>
>
>
>
date: Mon, 12 Mar 2007 22:10:00 -0700
author: Dan
Re: Countifs equiv in 2003
You're welcome. Thanks for the feedback!
Biff
"Dan" wrote in message
news:65374409-E58E-4B01-B043-6A62A13BE803@microsoft.com...
> Thank you!
>
> "T. Valko" wrote:
>
>> 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
>>
>> "Dan" wrote in message
>> news:5264A442-8710-4D81-81CD-F7CD3FD0B8EA@microsoft.com...
>> > 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. Valko" wrote:
>> >
>> >> =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
>> >>
>> >> "Dan" wrote in message
>> >> news:0C313761-70F8-4D29-8DE2-1BF9F8FF585F@microsoft.com...
>> >> >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!
>> >>
>> >>
>> >>
>>
>>
>>
date: Tue, 13 Mar 2007 01:23:41 -0400
author: T. Valko
|
|
