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:=countifs(a:a,"Yes")
Not working. This is what I put.
=countsifs(W3:AO3,"yes")
Try this=COUNTIF(A1:A8,"yes")
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:=COUNTIF(W3:AO3,"Yes")
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