countif ???

G

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
 
A

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
 
P

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
 
M

Myrna Larson

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