Here is the issue I am running into though, even though the columns are
formated to a date type this is how they are showing up when I am trying to
use the the syntax provided.
wait, I cant upload this screen shot, is there anyway I can display the issue?
--
Neall
"Dave Peterson" wrote:
Typo alert:
=sumproduct(--(isnumber(a1:a10),--(month(a1:a10)=8))
should have been:
=sumproduct(--(isnumber(a1:a10)),--(month(a1:a10)=8))
(I added a close paren.)
Dave Peterson wrote:
=sumproduct(--(isnumber(a1:a10),--(month(a1:a10)=8))
Adjust the ranges to match--but you can't use whole columns (except in xl2007).
=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.
Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html
========
If you were only interested in certain years:
=sumproduct(--(text(a1:a10,"yyyymm")="200708"))
Neall wrote:
I have a result from my MYSQL querry into excel and I want to use the list of
dates to count against, I now want to create a summary sheet. I want to use
the date colums and just pull a count of how many rows have the August date,
September date and October date (these month results will be in different
cells)
--
Neall
--
Dave Peterson
--
Dave Peterson