If I have a column with either yes or no in each cell is there a way to sum the total of yes's? =sum(?????
Thanks
If I have a column with either yes or no in each cell is there a way to sum the total of yes's? =sum(?????
Thanks
How aboutFormula:Please Login or Register to view this content.
Not working. This is what I put.
=countsifs(W3:AO3,"yes")
Try thisPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
In what way?Not working
It maybe that you have misspelt countifs
You originally said you had a column, but that formula is looking at a row.
your right it is a row, sorry. It gave me something like "name?" when I entered it.
That's because you have misspelt COUNTIFS you have an extra s in there.
Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks