Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!
View Course

Counting Secondary cell value

Free Excel Tips and Tutorials
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at

Counting Secondary cell value

Postby FrancisM » Wed Oct 30, 2013 11:37 am

If you have a secondary cell value that you want to count, the examples shown below are very easy to modify.

=COUNTA('Walk In'!A2:A500)-COUNTIF('Walk In'!A2:A500,"VBA")

The above formula will return the number of all entries in the examined range which are not "VBA".
If there is no space in the work sheet's name you can omit the apostrophe.

Posts: 44
Joined: Jan 30, 2013
Reputation: 0
Excel Version: 2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 1 guest