Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif or sumproduct range
I've been all around and tried many suggestions but still can't make this work.
Looking at one column of numbers on a separate worksheet that should be greater than 29 but less than 50, and if they meet this criteria I want the sum of another column of numbers on the separate worksheet added. I've tried sumproduct(--active!$P:$P29)*--(active!$P:$P<50),active!$g2:$g200) it returns #NUM! as an answer I have double checked and there are no errors or text entered in the G column -- Lori |
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 | |||
muliple sheet range + sumif / sumproduct | Excel Worksheet Functions | |||
HELP !!! SUMIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
SUMPRODUCT OR SUMIF | Excel Programming | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |