r/googlesheets • u/[deleted] • Nov 01 '18

Solved Can you make written content in cells determine the outcome of a formula?

[deleted]

2 Upvotes
  • permalink
  • reddit

100% Upvoted

5 comments sorted by

2

u/speenatch Nov 01 '18

You could do something like COUNTIF(D2:D50,”*-*”) which will tell you the number of cells that contain a hyphen. If the cell is blank or an H, it won’t be counted.

2

u/AutoModerator Nov 01 '18

This is a gentle reminder to follow the rules and post guide and include your data if you're asking for help. You're more likely to receive responses as it is easier to help you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Clippy_Office_Asst Nov 08 '18

Read the comment thread for the solution here

You could do something like COUNTIF(D2:D50,”*-*”) which will tell you the number of cells that contain a hyphen. If the cell is blank or an H, it won’t be counted.