| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with sumproduct
Hi all,
Need some help with a sumproduct I've been working on... =SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<"")*('Y10 Targets v WAG'!F4:F149="A*" OR "A" OR "B" OR "C")) It's a simple one working on two variables... Column K must not be blank, and column F must contain any of A*, A, B or C. Any help greatly appreciated. Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct instead of SumifS in VBA (application.sumproduct) | Excel Programming | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| SUMPRODUCT I think? | Excel Discussion (Misc queries) | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Threaded Mode
