Countif Funtion

  • Thread starter Thread starter David Harrison
  • Start date Start date
D

David Harrison

Hi there

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

Range - C4:D24

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
 
David Harrison said:
Hi there

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

Range - C4:D24

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
Click to expand...

Try this:
=SUMPRODUCT(--(C4:C24=D4:D24))
 
Back
Top