Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 04/09/04

Next message: Debra Dalgleish: "Re: Pivot table compatibility 2000 to XP"
Previous message: Mark Graesser: "Re: IF function problem"
In reply to: upstate_steve: "Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula"
Next in thread: upstate_steve: "Re: Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula"
Reply: upstate_steve: "Re: Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 9 Apr 2004 16:46:24 +0200

Hi
this is a little bit complicated without knowing a little bit more
about the design of your spread***. Could you post some example rows
of data 8plain text - no attachment please) and explain your expected
result based on this example

--
Regards
Frank Kabel
Frankfurt, Germany
> Hi
>
> Wouldn't
>
>
=SUMPRODUCT((ptft="PT")*(class="S")*(date>=$A23)*(date<$A23+7)*(ConvHrs
>> 0))
> give me the number of shifts worked, with most employees being
> represented by more than one shift?
>
> Among that set of rows counted by your formula, how do I get the
> number of unique values represented in the additional field EmpNo?
>
> Thanks
>
>
> ---
> Message posted from http://www.ExcelForum.com/

Next message: Debra Dalgleish: "Re: Pivot table compatibility 2000 to XP"
Previous message: Mark Graesser: "Re: IF function problem"
In reply to: upstate_steve: "Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula"
Next in thread: upstate_steve: "Re: Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula"
Reply: upstate_steve: "Re: Re: Re: counting selected rows among those returned as "TRUE" by an array sum formula"
Messages sorted by: [ date ] [ thread ]