Prev: Using Iserror with If statement and Vlookup
Next: colating multi rows of data into single rows - no to pivot tab
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" <lwsnbaker(a)discussions.microsoft.com> 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"


 | 
Pages: 1
Prev: Using Iserror with If statement and Vlookup
Next: colating multi rows of data into single rows - no to pivot tab