another IF query ......

E

englishrose4719

OK thats it - i give up!!! im going for the hanging myself option now.
Didnt like that one at all. I'll write in words what i need:

IF "there is at least one cell within the range 'Test Data'!AD26:AE43 that
contains a value,
AND,
there are NO cells within the range 'Test Data'!Z26:Z43 that contain any
values" OR,
there are NO cells within the range 'Test Data'!AB26:AB43 that contain any
values",
then return that total number of values.

ie: If column AD/AE is populated and column Z and/or column AB is populated,
remove them from the count. count how many 'populated' values are left in
AD/AE and give me the total.
I THINK!

I hate logic!!!
 
C

CLR

No hanging allowed.........never give up!!!
Maybe this one...........

=IF(AND(COUNTA('Test Data'!AD26:AE43)<>0,COUNTA('Test
Data'!Z26:Z43)=0,COUNTA('Test Data'!AB26:AB43)=0),COUNTA('Test
Data'!AD26:AE43),"")

Vaya con Dios,
Chuck, CABGx3
 
E

englishrose4719

Oh dear - no joy with that one either - doesnt give me anything at all. Is
it allowable that i fax or (e)mail you a copy of my spreadsheet so you can
actually see what i need to do - im wondering if im making the issue more
complicated by not explaining it very well. I feel really awful keep asking
you for help - i know you said you dont mind but even so ......
 
C

CLR

Of course you can email me a file, but you must NOT post it to the
group.....send it here at this computer....and I am leaving for work now and
won't be back at this computer for 11 hours....about 5pm my time here in St.
Petersburg Florida...........I will look at it this evening and get back to
you....

[email protected]

remove the obvious from the above email addy

And, when you say this new formula "doesn't give you anything at all", does
that mean you only get a blank cell, no matter how you might populate the
different ranges?

Looking forward to getting your file.........
Vaya con Dios,
Chuck, CABGx3
 
Top