Hi all,
I have a problem. In some cells A1:AD1 are the texts, the rest are empty.
1. If I mark A2: Z2 and introduce a formula
completed Ctrl + Shift + Enter in these cells have values 0/1Please Login or Register to view this content.
2. If I mark A3: Z3 and introduce a formula
completed Ctrl + Shift + Enter in these cells have the same value as in the case of using COUNTA in step 1.Please Login or Register to view this content.
3. If you have a formula for A4
in the A4 I have the result of "OK" or "" depends on the content A1:AD1Please Login or Register to view this content.
4. If you have a formula for A5
I have it in A5 #N/A (Ecel 2007) or ""Please Login or Register to view this content.
My question:
1. Why formula
It is correct (result = OK) and the formulaPlease Login or Register to view this content.
It is no longer correct (result = #N/A or "")?Please Login or Register to view this content.
After all, and in step 1 and step 2 are returned to the same horizontal arrays.
2. In this particular case, what feature SUBTOTAL decides that the SUBTOTAL formula is correct?
Sorry, I do not know English
Thank you.
Tomek
Bookmarks