Sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to the count the number of times a value, represent in column B1 in
sheet 1 appears in the range H1:h15000 in another worksheet

Thanks

ce
 
Hi, Curtis.

Your question isn't too clear, but it sounds like you can use COUNTIF, since
you only have 1 criteria:

=COUNTIF('Sheet2'!H1:H15000,'Sheet1'!B1)

If that is not what you are looking for, please provide better details.

Jason
 
You must log in or register to reply here.

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 with either text of number format 4
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Set add function ignore #N/A 1
Excel How to find the most common pairs and triplets numbers? 5
Scrabble Value calculation for Welsh words 0
Countif Help 1
Excel Numbering rows by font color, but skipping blanks 1
Count with multiple conditions 1

Back
Top