Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum with multiple conditions
I'm trying to write a sumproduct formula with mulitple conditions:
C6=4/25/08 C44=Project121 I'm using: =SUMPRODUCT(--(Sheet1!K$2:K$50001<=--C$6),--(Sheet1!E$2:E$50001=C44),Sheet1!T$2:T$50001) I want to sum the values in column T with the specific data in C44 athat has a date less than 4/25/08. The data in column C changes, so C43 could be Project151. Also I want the date to alway be the current date, that is why I'm refrencing it to a specific cell, using =today(). I keep getting a #ref! error. The previous formula I was using was working but it didn't factor in the date. =SUMIF(Sheet1!$E$2:$E$50001,C44,Sheet1!T$2:T$50001 ) Can anyone help? Using Excel2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
How do I add multiple values that match multiple conditions? | Excel Discussion (Misc queries) | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |