Tuesday, October 28, 2014

yogi_Count The Number Of Times A Title is Submitted Accepted Rejected

                 Google Spreadsheet   Post  #1809
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-29-2014
post by  Zac622:
I have values that are either accepted, denied or pending. How do I count each?
I know next to nothing about google spreadsheets or excel so I'm learning as much as I can. Here is my problem.

Background: I'm a creative writer and I want to track where my pieces get submitted to, how many times they get submitted, how many times they are accepted/rejected and when. I have most of that working for me but...

Right now I have it so when I enter the title of something, it adds it to a list and starts counting how many times that title occurs which works great.

However, I need to manually enter when a piece of mine is accepted or rejected, and until I enter one of those, it automatically puts it as pending and starts counting how long it has been since I sent something in. The problem I have is that I want to be able to see in my list how many times something is accepted AND rejected AND how many are currently pending.

I simply cannot figure this out. The problem comes within the fact that the data I enter for new titles will be in random locations. Can someone help please I've wracked my brain for three days.

Thank you.