sumif

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

Guest

I'm trying to get the sum of a list of numbers that start with a certain
group of 7 numbers (in this example 1234567). I've tried
=SUMPRODUCT(--(LEFT(A1:A1000,7)=1234567),B1:T1000) to no avail. Can someone
help out with this?Thanks in advance.
 
If all the numbers you are trying to sum are in column B, this should work,

=SUMPRODUCT(--(LEFT(A1:A1000,7)="1234567"),B1:B1000)
 
Thanks. It's always the simple things...

Nikki said:
If all the numbers you are trying to sum are in column B, this should work,

=SUMPRODUCT(--(LEFT(A1:A1000,7)="1234567"),B1:B1000)
Click to expand...
 

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

start and end date on different rows 1
Extracting 7 digit number from alphanumeric string 10
Merge Cells 2
sum multiple columns with SUMIF or SUMPRODUCT 2
Using a SUMIF and Parsing to sum part of a cell 6
Wildcard with sumif 13
Last 4 4
Sumif Horizontal 6

Back
Top