sumif left

  • Thread starter Thread starter brianwa
  • Start date Start date
B

brianwa

Help, I'm using the below formula to sum a list of products by part# and
I keep getting a #NUM! error message. I've entered it as an array
formula. I've checked all of the part #s and they are correct.

=SUM(IF(LEFT(Sheet2!$B:$B,4)="4665",Sheet2!D:D))

Thanks in advance
 
Arrays don't like Full column references - Amend it to the following:-

=SUM(IF(LEFT(Sheet2!$B1:$B65535,4)="4665",Sheet2!D1:D65535))
 
Thanks Ken,

Murphy's law, as soon as I posted my question I figured it out.
Thanks for your help though. It's great to have this forum to help.
I'm going for more coffee now!

BW
 
My pleasure - Take a look at Peo's post as well, as this saves you having to
array enter it. Just change the references to your own.
 
Back
Top