SUMIF with area that is not a range
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,D I8
if "paid"
The cells can't be summed if the contain "paid".
|