![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |