Any experts on "countif" formula using nested conditions

  • Thread starter Thread starter Chuck
  • Start date Start date
My parochialism Frank. I accounted for US/European date styles, and then
forgot language.

Back to the drawing board.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Norman Harker said:
The English and Australians were dragged
kicking and screaming to accept metrication so I don't harbour a lot
of hopes of seeing it soon.
Click to expand...

You obviously haven't lived in England for a long time if you think we have
accepted metrication.
 
Bob said:
My parochialism Frank. I accounted for US/European date styles, and
then forgot language.

Back to the drawing board.
Click to expand...

Bob
always the same with the islanders in the EU <vbg>
Frank
 
Of course, this is the same as *1, and is fast becoming the accepted
standard, surprised that Harlan hasn't jumped in.

I resolve to adopt the yyyy-mm-dd style from now on, even if my countrymen
don't.

This has been good! Jason's little tid-bit has led to some interesting
thoughts and a New Year's resolution for me.

Thanks everyone.

Bob
 
Hi Bob!

Know what you mean!

I could understand changing the system but to pick one invented by the
French is unforgivable <gdr>

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Bob!

Agreed that's what we should do but...

Re: "a New Year's resolution for me"

Old habit die hard! England abandoned New Year starting on 26-Mar in
1752 (which if you add the 11 days for Gregorian calendar reform is
the basis for your FY beginning on 6th-Apr.)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Nobody told me!

Bob

Norman Harker said:
Hi Bob!

Agreed that's what we should do but...

Re: "a New Year's resolution for me"

Old habit die hard! England abandoned New Year starting on 26-Mar in
1752 (which if you add the 11 days for Gregorian calendar reform is
the basis for your FY beginning on 6th-Apr.)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Excellent, thank you gentlemen

-----Original Message-----
Hi Chuck!

See Bob and Jason's solutions. You can't use multiple conditions
within COUNTIF or SUMIF.

Generally we use SUMPRODUCT although you can often use two COUNTIF
functions:

=COUNTIF(A1:A300,">="&"4-Jan-2004")-COUNTIF (A1:A300,">"&"4-Jul-2004")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Excellent, thank you gentlemen


-----Original Message-----
SUMPRODUCT is usually the method of choice when counting
or summing based on multiple criteria:

=SUMPRODUCT((A1:A300>="4/1/04"*1)*(A1:A300<="4/7/04"*1))

HTH
Jason
Atlanta, GA

.
Click to expand...
 
Excellent, thank you gentlemen



-----Original Message-----
=SUMPRODUCT((A1:A300>=Date(2003,04,01)*(A1:A300<=DATE (2004,04,07))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Back
Top