Lyteck Lynhiavu
asked on
Functions not working in xlsm (Excel 2010)
Hi, I've been developing this attached spreadsheet with the help of a few experts here. I've expanded upon it and am running into a couple of simple but puzzling problems.
Q1. How come Cell A1 and A2 are not computing??
A1 =COUNTA(A6:A23)
A2 =SUM(E6:E31)
I must have entered a "mode" in Excel but don't know what it is. The cells literally display the above formulas instead of computing the values.
Q2. in Column P and Q I have conditional formatting. How come only column P is highlighted? P and Q should both be highlighted as the range applies to both columns.
Thanks and best regards, Lyteck
Field-validation-test.xlsm
Q1. How come Cell A1 and A2 are not computing??
A1 =COUNTA(A6:A23)
A2 =SUM(E6:E31)
I must have entered a "mode" in Excel but don't know what it is. The cells literally display the above formulas instead of computing the values.
Q2. in Column P and Q I have conditional formatting. How come only column P is highlighted? P and Q should both be highlighted as the range applies to both columns.
Thanks and best regards, Lyteck
Field-validation-test.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent and straight to the point. Thanks for your speed. Best, Lyteck
ASKER
Any idea perhaps on the formatting of column Q? (my second question)