Thread: [Solved] Count of non-blank cells in one row and specified content in another
View Single Post
 
Old 04-20-2021, 09:15 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default 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
Reply With Quote