• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

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
0
lyteck
Asked:
lyteck
  • 2
  • 2
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Press ctrl-`

it is the backwards apostrophe. On my keyboard it is below the Esc key next to 1
0
 
lyteckAuthor Commented:
Ok that did it! Thanks a lot.

Any idea perhaps on the formatting of column Q? (my second question)
0
 
Saqib Husain, SyedEngineerCommented:
Sorry, missed that part.

Change the formula to

=AND(IF(($D6="Y"),TRUE),COUNTIF(P6:Q6,"<>")<>2)

$ sign with D
0
 
lyteckAuthor Commented:
Excellent and straight to the point. Thanks for your speed. Best, Lyteck
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now