SUMPRODUCT ?

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula is summing text and I want it to stop doing that 2
COUNTIF + ADDRESS Issue 1
Macro to Select text from a point given to a specific word 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Using <= in countifs statement 1
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
Sumproduct with if statement 4

Top