Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 99
  • Last Modified:

#Value Error

As per attached spreadsheet, When a character is entered in cell in column S (say, S24), it gives a #value error in cell Z34.
If column S is blank, there is no error and the sum value appears.

All help/suggestions is appreciated.
Thank you
0
Farah Mohammed
Asked:
Farah Mohammed
  • 2
1 Solution
 
Neil RussellTechnical Development LeadCommented:
No attachment?
0
 
Farah MohammedBuyerAuthor Commented:
Sorry, here is the attachment.
--orbitonline.com-Private-NSL-HomeDir-fa
0
 
Farah MohammedBuyerAuthor Commented:
I used SUM(Z24,Z25,Z26) instead of SUM(Z24:Z26).

Thank you
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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