How to use counta function in Excel?
Thread Starter
Scooby Regular
Joined: Dec 2001
Posts: 12,387
Likes: 0
From: Arborfield, Berkshire
How to use counta function in Excel?
Aargh all I want to do is count the number of cells in a range that contain the string YES. Ive tried following the help file and used counta(A1:A150, YES) and counta (A1:A150, "YES") but they dont work.
Anyone who can actual use Excel know what Im doing wrong?
Cheers
Simon
Anyone who can actual use Excel know what Im doing wrong?
Cheers
Simon
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM