| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct for Values over a certain Value eg 0.00
Hi
I am using the code below and only want to sum the Values over 0.00, but if I add 0 to this it does the COUNT. Please can you let me know if there is a way of doing this. I have searched and cannot find, maybe I am heading in the wrong direction. =SUMPRODUCT(--('FULL CURRENT ATB'!$C$2:$C$4030=$B$3)*('FULL CURRENT ATB'!$O$2:$O$4030)) Thanking you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
| Two Matches, then Sumproduct of Values | Excel Worksheet Functions | |||
| Toggle values with SUMPRODUCT | Excel Discussion (Misc queries) | |||
| SUMPRODUCT on multiple values | Excel Discussion (Misc queries) | |||
| Obtaining Max and Min Values with Sumproduct | Excel Discussion (Misc queries) | |||
Threaded Mode
