Google Spreadsheet Post #2567
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jan-06-2019
question by: Ryan Epps:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/tilxpnZ1bxI;context-place=mydiscussions
Whats the right formula for adding the number of times something occurs?
I have the following spreadsheet and I wondered if there was a formula to find out the totals of things like, how many Sunday matinees there are, or how many evening performances. I cant seem to find a formula that works, I have tried =COUNTIF(B4:B,"19:30") and others but they never work, would it be because I have used data validation in column B? any help would be really appreciated.
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/tilxpnZ1bxI;context-place=mydiscussions
Whats the right formula for adding the number of times something occurs?
I have the following spreadsheet and I wondered if there was a formula to find out the totals of things like, how many Sunday matinees there are, or how many evening performances. I cant seem to find a formula that works, I have tried =COUNTIF(B4:B,"19:30") and others but they never work, would it be because I have used data validation in column B? any help would be really appreciated.
No comments:
Post a Comment