Prev: setting cell values based on a 3rd cell
Next: Unique Rank with Duplicate Entries
From: T. Valko on 31 Mar 2010 12:36
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"J.Scargill" <JScargill(a)discussions.microsoft.com> wrote in message
news:919C40EF-3F82-48B3-82B6-F714E5AB99FA(a)microsoft.com...
> Great, thanks for your help with this and the last few Biff! Greatly
> appreciated.
>
> "T. Valko" wrote:
>
>> Try one of these...
>>
>> Any version of Excel:
>>
>> =SUMPRODUCT(--(Q14:Q10000="A01"),--(R14:R10000=62))
>>
>> Excel 2007 or later:
>>
>> =COUNTIFS(Q14:Q10000,"A01",R14:R10000,62)
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "J.Scargill" <JScargill(a)discussions.microsoft.com> wrote in message
>> news:3163A00C-3A90-4515-8517-E48BEAEF2EA1(a)microsoft.com...
>> > Hi guys,
>> > Need some help with a formula please. Have tried myself and know that
>> > the
>> > answer is straightforward but going through a mental block!
>> >
>> > Col Q Col R
>> > A01 58
>> > A01 62
>> > P02 62
>> >
>> > Both columns data starts in cell 14 and runs down to cell 10000.
>> > I need to count the entries in Column Q that = A01 ONLY IF Col R = 62.
>> > Then
>> > do the same for Q = A01 ONLY IF R = 58, and so on. The worksheet is a
>> > year-to-date file and will be updated weekly with many entries in both
>> > columns with varying values.
>> >
>> > Many thanks.
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: setting cell values based on a 3rd cell
Next: Unique Rank with Duplicate Entries