different SUMIF

  • Thread starter Thread starter Gaurav
  • Start date Start date
Try this approach:

=SUMPRODUCT((LEFT(A1:A1000,3)="000")*(P1:P1000))

I've assumed 1000 rows, so adjust to suit, but you can't use full
column references prior to XL 2007.

Hope this helps.

Pete
 
=SUMIF(A:A,"0000*",P:P)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
thanks bob this worked. another one...now I want to sum the rest of the
values. means....sum column P where values in column A dont start with 000.
 
Thanks Pete...but i am getting the VALUE errror as result.


Try this approach:

=SUMPRODUCT((LEFT(A1:A1000,3)="000")*(P1:P1000))

I've assumed 1000 rows, so adjust to suit, but you can't use full
column references prior to XL 2007.

Hope this helps.

Pete
 
oh I got it

=SUMIF(A:A,"<>000*",P:P)

Thanks :)

Bob Phillips said:
=SUMIF(A:A,"0000*",P:P)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)
Click to expand...
 
I see you have an answer from Bob that works for you, but you might
like to try this amendment:

=SUMPRODUCT(--(LEFT(A1:A1000,3)="000"),P1:P1000)

Hope this helps.

Pete
 
Back
Top