finding data between two numbers (1000-1999)and totaling correspo.

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

Guest

I have a list of four digit numbers. I need to search the list and any that
start with 10.. I have to total the numbers from a corresponding column of
all that match this criteria and display it.
 
one way:

With 4 digit numbers in A1:A1000, and corresponding column B:


=SUMPRODUCT(--(INT(A1:A1000/100)=10),B1:B1000)
 
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

Macro to add numbers in a text string 5
Creating items list with corresponding prices 6
How do I compare the stored data in micro 3
Cross-Referencng numbers between worksheets 3
merging two sets of data 2
Find the lowest number? 3
Retrieve multiple data rows data from a very long list and copy t 1
Copying by Sequence Number 1

Back
Top