Hi,

Does anybody have the answer to this:

I have a worksheet with a "Date Column" and a "Model No. Column" I
want to be able to check the entire two columns using a formula and
have the worksheet count the no. of "model no.s" that are equal to X
on a month by month basis, e.g. Jan-08, Feb-08, Mar-08

e.g. all model numbers that are equal to EC80 during the month of
Jan..

I know I probably need to be using multiple IF statements but I'm at a
complete loss on how to do this...

maybe something like

where A = Date Column
where B = Model Column

=IF(A:A01/01/08<31/01/08,COUNTIF(B:B,"EC80"),)

although this doesn't work

Any help much appreciated!

Thanks Jon