From: lwsnbaker on 12 Mar 2010 10:14 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" From: Glenn on 12 Mar 2010 10:19 lwsnbaker wrote:> 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" The cells can't be summed if the contain "paid". From: Luke M on 12 Mar 2010 10:49 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)) -- Best Regards, Luke M "lwsnbaker" wrote in message news:C6F42430-C078-4D4E-89D8-511BA1324D2D(a)microsoft.com...>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"