Countif Funtion

[David Harrison]

Hi there

Hope some one can help me. this is not a particuarly
difficult one.

Range - C424

What i want is that if the two cells C4 and D4 have the
same value for it to be counted down in cell E12. This is
to be the same for all the other cells in that range.

I.e. C5 & D5
C6 & D6 all the way down to row 24!!!

Thanks very much

David

 

[Paul]

Hi there

Hope some one can help me. this is not a particuarly
difficult one.

Range - C424

What i want is that if the two cells C4 and D4 have the
same value for it to be counted down in cell E12. This is
to be the same for all the other cells in that range.

I.e. C5 & D5
C6 & D6 all the way down to row 24!!!

Thanks very much

David

Try this:
=SUMPRODUCT(--(C4:C24=D424))