Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
Hi,
I am new to using the sumproduct formula, would someone be able to tell why the following is not working: =SUMPRODUCT('Detail Hours'!A1:A60000=A9)*('Detail Hours'!A1:A60000<"")*('Detail Hours'!H1:H60000) Thanks -- CK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Using SUMPRODUCT... | Excel Worksheet Functions | |||
SUMPRODUCT help | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions |