[mso] Re: FW: CountIF help
- From: "Greg Chapman" <greg@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 15 Sep 2003 17:38:58 -0500
BTW, here's an excellent way to check all this out. I encountered this
while trying to keep the thread straight and use Excel at the same time.
The results gave me amusement and may give you a chuckle too.
I copied Colin's original message into a single cell in Excel (here it
is):
================================================================
Hi
I'm trying to do a check on the number of dates in a row which are less
than
(or equal to) today's date. This figure would then be used in a
calculation.
I have tried various options, but without success. My target is to have
=COUNTIF(a2:O2,"<=Today")
But I'm getting a 0 result, even tho there should be several.
I've checked formatting for all dates is correct, and that the CountIF is
formatted as a Number.
I must be missing something obvious, but can't see it.
Thanks in advance.
================================================================
Well, pasted in that way in cell 4 of Column A, the line containing the
formula quickly changed to 0 and I had a hell of a time remembering
exactly what he wrote. So, under all that, I placed a quote, pasted the
formula and typed another quote. Now I could see his formula again. In
cells A2-D2, I typed some dates, some older and some newer than today. I
still showed a 0 in the formula line.
In another cell, I did it the Ray way, or
=COUNTIF(a2:O2,"<=" & Today())
Which produced the proper comparison results.
Strings are fun and if you get this under control you're only half a step
from falling over the edge of programming, chum! (Mwaa-haa-haa-haaaaa! The
evil scheme is working!)
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Linda F. Johnson
> Sent: Monday, September 15, 2003 6:08 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: FW: CountIF help
>
>
> No Greg...actually the COUNTIF formula DOES require quotes
> where you put the
> criteria...you try to do a COUNTIF without the quotes and
> Excel won't accept
> it
>
> For example, if you want the count of all numbers in a range that are
> greater than 10, the formula would read =COUNTIF(A1:A100,"<10")
>
> And that's why Excel sees it as a string...cuz Excel sees all stuff in
> quotes as a string of text.
>
> I guess the next discussion could be why the hell does Excel
> make you put
> the criteria in quotes in a COUNTIF formula if it doesn't
> make you do that
> in an IF statement LOL
>
>
>
> Linda F. Johnson, M.A., MOS
> Linda's Computer Stop
> http://personal-computer-tutor.com
> Free e-Books, Newsletter, and tutorials
>
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
