countif ???

[GazMo]

Thanks - But not really wot I'm after ... I'm trying to populate source
data for a graph and i need values for each number of days for each
month eg how many times 1 to 10 appear when the month is Jan etc

 

[Alex Delamain]

Then using a pivot table / pivot chart should be what you need. A pivo
table of the data you posted comes out like the one below


Count of Days Days
_Month ________________1 2 3 Grand_Total_
Jan 1 2 3
Feb 2 2
Grand Total 1 2 2

 

[Peo Sjoblom]

You know, you could quote the post you are posting an answer to! I have no
clues what you are not after and I won't search threads to find out, so you
really cut off help from at least some people

Regards,

Peo Sjoblom

 

[Myrna Larson]

Ah, but this IS what you are after. You need multiple formulas, replacing the
1 with 2, 3, 4, etc.