Count of non-blank cells in one row and specified content in another

		Microsoft Office Forums > Microsoft Excel > Excel
Count of non-blank cells in one row and specified content in another

04-21-2021, 12:13 PM

trevorc

Windows 7 32bit Count of non-blank cells in one row and specified content in another

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

Thanks Arvi,
Works just fine. Is there a way to use a named range from within the table in place of the range?

regards
Trevor

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to count the number of cells ending with 001 or 002	mgroessl	Excel Programming	5	08-06-2019 03:39 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Count if another cell is blank	caz46	Excel	4	11-02-2015 07:25 AM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:01 AM.