SUMIF with area that is not a range

  • Thread starter Thread starter lwsnbaker
  • Start date Start date
L

lwsnbaker

I am trying to sumif cells that are not consecutive.

Here is what I have so far
=IF((I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,DI8),"paid",(I8+Q8+Y8+AG8+AO8+AW8+BE8+BM8+BU8+CC8+CK8+CS8+DA8+DI8))

These cells need a sum:
I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,DI8

if "paid"
 
lwsnbaker said:
I am trying to sumif cells that are not consecutive.

Here is what I have so far:
=IF((I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,DI8),"paid",(I8+Q8+Y8+AG8+AO8+AW8+BE8+BM8+BU8+CC8+CK8+CS8+DA8+DI8))

These cells need a sum:
I8,Q8,Y8,AG8,AO8,AW8,BE8,BM8,BU8,CC8,CK8,CS8,DA8,DI8

if "paid"
Click to expand...

The cells can't be summed if the contain "paid".
 
As Glenn said, you can't SUM things with text, but in case you really wanted
to Count, you can do this:
=SUMPRODUCT(--(NOT(MOD(COLUMN(I8:DI8)-1,8))),--(I8:DI8="paid"))

If your summed values are really in another row, something like:
=SUMPRODUCT(--(NOT(MOD(COLUMN(I8:DI8)-1,8))),--(I8:DI8="paid"),(I10:DI10))
 
Back
Top