|
|
#3
05-23-2018, 08:35 AM
|
|||
|
|||
Hi
I think you need to also coerce your Lefts from Text values to Numbers and, your second part I think the test should be = and not <> Code:
=SUMPRODUCT(--(--LEFT([workbook.xlsx]Sheet!$A1:INDEX([workbook.xlsx]Sheet!$A:$A, MATCH("zzz", [workbook.xlsx]Sheet!$A:$A)), LEN(C1))=C1),
--(--LEFT([workbook.xlsx]Sheet!$A1:INDEX([workbook.xlsx]Sheet!$A:$A, MATCH("zzz", [workbook.xlsx]Sheet!$A:$A)), LEN(D1))D1))
|
| Tags |
| excel formula, sumproduct |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
 Counting multiple data in cell more than once
|
Alaska1 | Excel | 3 | 03-01-2015 04:27 PM |
| Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
|
various data needs counting
|
apples | Excel | 2 | 09-16-2012 04:52 AM |
|
macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Windows 10 
Office 2016
Threaded Mode