Is there a way to get rid of "######"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A6 contains this formula:
=SUMPRODUCT(--(A1:A5>8/24),A1:A5-8/24)*(SUM(A1:A5)*24<40)

This formula is doing what I want however if I enter a word into one of the
data cells instead of a time, the cell with the formula says ######. Is there
a way to have the formula only recognize a time entry and ignore a word entry
and still do the calculations I need.
 
Toppers,
That formula is ignoring both words and time entry in the before mentioned
cells.
Any more suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get rid of "#######" 1
Is there a formula........... 4
SUMPRODUCT 1
issue with "left" 5
Sum number range ignoring numbers formatted as text 0
Formula Content linked to other cells formula Content 5
If cell entry does not match options = error 1
Is INDEX,MATCH the best way? 11

Back
Top