sumif

T

tacgibeht

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.
 
N

Nikki

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

=SUMPRODUCT(--(LEFT(A1:A1000,7)="1234567"),B1:B1000)
 
T

tacgibeht

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...
 
Top