"Relative Reference Issue"

**smj276** · 03-05-2009, 06:04 AM

Hi everyone.
I'm stumped, and I'm sure its a simple fix, but I can't figure it out.

I can get this formula work running down a page =IF(COUNTIF(C9:C14,"x")=ROWS(C9:C14),"Complete","Not Complete")

but

It does not work running across,
=IF(COUNTIF(C9:G9,"x")=ROWS(C9:G9),"Complete","Not Complete")

What am I missing???
So frustrating!!!!

S

**DonkeyOte** · 03-05-2009, 06:14 AM

Firstly, please rephrase your Q to something meaningful related to your question - perhaps "Relative Reference Issue"

Secondly, ROWS(C9:G9) will always be 1 as there is one row in the range... it strikes me you want to perhaps think about switching to COLUMNS or rewriting:

=IF(COUNTIF(C9:G9,"<>x"),"Not ","")&"Complete"

**smj276** · 03-05-2009, 05:31 PM

Thanks heaps.

I was way off the mark but it's all good now
Cheers
Shane

**VBA Noob** · 03-05-2009, 05:33 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save