I have tried a million ways of looking for this and have done a work around by putting it in a hidden column but I'm sure there is another way! I have columns with either y, yy or yyy in each cell. I want the bottom row to add up the number of ys so if "y" then 1, if "yy", then 2, if "yyy" then 3 and add them up. like this:
y
yy
yyy
6
I have this so far
=SUM(COUNTIF(C2:C43,"y"),COUNTIF(C2:C43,"yy"),COUNTIF(C2:C43,"yyy"))
All that gives me is the sum of every occurence rather than a total of ys like this (I don't want this version):
y
yy
yyy
3
I'm sorry if none of that made the blindest bit of sense. Any help would be very gratefully received.
Thanks
Bookmarks