How to use counta function in Excel?
#1
Scooby Regular
Thread Starter
Join Date: Dec 2001
Location: Arborfield, Berkshire
Posts: 12,387
Likes: 0
Received 0 Likes
on
0 Posts
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
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM