| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5))
=SUMPRODUCT(--((John)=$A5))
Defined field John = 'Access Data'!B$1:B$65000 This works, however I don't want it to go through 65000 each time, only the number of rows that have data, hence tried =SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5)) where aaaa is defined as a cell with the count of rows, but Excel returns #Value. Is there any way to do this. PS. Need to use SUMPRODUCT as the full statement is =IF($D6<" ",SUMPRODUCT(--(SEVERITY=$A6),--(BREACHYORN="NOBREACH")++(BREACHYORN = "NOSLA"),--(ROLL_MONTH_NUM = 1))," ") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot save Project file as MS Access file | Excel Discussion (Misc queries) | |||
| Linking Large Access Table into Excel | Links and Linking in Excel | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Excel and Access talking | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
