J
Jon
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:A>01/01/08<31/01/08,COUNTIF(B:B,"EC80"),)
although this doesn't work
Any help much appreciated!
Thanks Jon
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:A>01/01/08<31/01/08,COUNTIF(B:B,"EC80"),)
although this doesn't work
Any help much appreciated!
Thanks Jon