Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-20-2021, 09:15 PM
trevorc trevorc is offline Count of non-blank cells in one row and specified content in another Windows 7 32bit Count of non-blank cells in one row and specified content in another Office 2013
Competent Performer
Count of non-blank cells in one row and specified content in another
 
Join Date: Jan 2017
Posts: 173
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Count of non-blank cells in one row and specified content in another 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 of non-blank cells in one row and specified content in another 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 09:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft