Countif with more than one criteria
=SUMPRODUCT(--($B$1:$B$105=--"2006-01-01"),--($B$1:$B$105<=--"2006-03-30")
as an example
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Joco" wrote in message
...
hi
I have read the various discussions on countif and can't find the correct
solution to my question.
My spreadsheet contains dates in column B. I want to show a summary in a
single cell for each year, firstly the year (2004) and secondly the number
of
individual dates for that year (16)
I have used ="2004"&" "&countif(b1:b105,"<383532) this works fine for
the 1st year.
For the second year the formula needs to show from and to numbers,
representing the first and last dates in the year.
I have tried a countif -countif fomula, but this shows an incorrect numer
Any help would be greatly appreciated
Thanks Joco in London
|