New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Counting Secondary cell value

Free Excel Tips and Tutorials

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 5 guests

cron