Is there any way I can make a column of Y's add up as though it were a column of 1's. I need to put Y for Yes but want to know how many of them there are.Thanks in advance
as in=COUNTIF(A1:A5,"y")will count all the entries in A1 to A5 that contain yHope this helps :-)
Perfect!!!!!!! Thank you, just what I wanted.
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.