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

FAQ

Thread Tools

Display Modes

04-20-2021, 09:15 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

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

Hi All,

I'm trying to get this countif to give me a count of cells that are not blank in one row and contain 'Tablet' in the other, both rows are located on another sheet.

=COUNTIF('Repairs'!R6:R5000,"<>" + 'Repairs'!e6:e5000,"Tablet")

And is there a way to make this dynamic in a table row? can i use the row named range?

Any help would be great, even a point in the right direction

regards
Trevor

« Previous Thread | Next Thread »

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 03:42 AM.