New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

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 TeachExcel.com.

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.

=COUNTA(IT!B2:B500)-COUNTIF(IT!B2:B500,"VBA")
FrancisM
Regular
 
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