SUMPRODUCT ?

  • Thread starter Thread starter Alex Hammerstein
  • Start date Start date
A

Alex Hammerstein

Hi

In C4 on Sheet 1 I want to count the number of instances where the text in
Data!Z4:Z5000 is the same as Sheet1!A4.

I am trying to use SUMPRODUCT, but I think that this is probably the wrong
function.

Can anyone advise please?

Thanks

A
 
I'd try this in C4:
=countif(data!z4:z5000,A4)

Since the formula is in the same sheet as A4, the sheet name doesn't need to be
included.
 
Back
Top