Any experts on "countif" formula using nested conditions

[Bob Phillips]

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)

 

[Bob Phillips]

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.

You obviously haven't lived in England for a long time if you think we have
accepted metrication.

 

[Bob Phillips]

They will never accept these changes

Hey you, we're more European than the Europeans these days - Tony tells us
(regularly!).

 

[Frank Kabel]

My parochialism Frank. I accounted for US/European date styles, and
then forgot language.

Back to the drawing board.

Bob
always the same with the islanders in the EU <vbg>
Frank

 

[Frank Kabel]

Hey you, we're more European than the Europeans these days - Tony
tells us (regularly!).

rotflol

Frank

 

[Bob Phillips]

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

 

[Norman Harker]

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.

 

[Norman Harker]

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.

 

[Bob Phillips]

Nobody told me!

Bob

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.

 

[Chuck]

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.



.

 

[Chuck]

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

.

 

[Chuck]

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)




.