Re: Count If Conditions Are Trus

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michael (anonymous_at_discussions.microsoft.com)
Date: 03/07/04 

Date: Sun, 7 Mar 2004 15:40:40 -0800

Hi Bob
Your right....and it's only Monday. I don't where that
came from. Yes, the AND condition was required.
I need more coffee.
Regards
Michael
>-----Original Message-----
>Michael,
>
>I was not aware that this worked, and testing it suggests
that it doesn't.
>Apart from omitting row 2, are you saying that this is
and AND condition for
>>6 and <30?
>
>--
>
>HTH
>
>Bob Phillips
> ... looking out across Poole Harbour to the Purbecks
>(remove nothere from the email address if mailing direct)
>
>"Michael" <anonymous@discussions.microsoft.com> wrote in
message
>news:87ad01c40490$5d8956e0$a001280a@phx.gbl...
>> Hi
>> Try:
>>
>> =COUNTIF(A1:R1,{">6","<30"})
>> Regards
>> Michael
>> >-----Original Message-----
>> >Hi,
>> >
>> >I have a spreadsheet with various values in a1:r1 and
>> a2:r2, I want to count when a1 is greater than six and
a2
>> is less than thirty (i.e. when both are true not either
>> or). I initially did an IF statement which is fine and
>> then a calculation at the end, however, it's not too
smart
>> and I thought there must be a better way. I thought
about
>> an array but that may as well be greek to me, I also
>> thought it might work with an AND statement in a countif
>> but am having no joy. Can anyone help?
>> >
>> >Thanks,
>> >
>> >Best Regards,
>> >
>> >CalumMurdo Kennedy
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: Count If Conditions Are Trus
    ... > Hi Bob ... > I need more coffee. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Honest carb question
    ... Michael, why would people for whom coffee doesn't spike them reply to ... insulin resposne to the meal (phase ii response) and being "faulty" it kept ... readings were about 4 hours after the meals, ...
    (alt.support.diabetes)
  • Re: No Presidential First Pitch!
    ... : mitchell says: ... And your point in regards to McMahon is what. ... densethis morning because my coffee has yet to kick in. ...
    (alt.sports.baseball.bos-redsox)
  • Re: Honest carb question
    ... Michael, why would people for whom coffee doesn't spike them reply to ... I currently have rather high BGs with some rather lows. ...
    (alt.support.diabetes)
  • Re: Honest carb question
    ... opinions. ... response I got a few months ago about this question looked to me like ... Michael, why would people for whom coffee doesn't spike them reply to ...
    (alt.support.diabetes)