G
Guest
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
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