| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple conditions
Help pls!
Need a formula to do the following: if date in range matches date in a cell then sumif function... the formula doesn't take the if fucntion relating to date in account... -ellie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple conditions
More info and before/after examples
-- Don Guillett Microsoft MVP Excel SalesAid Software "Ellie Sarmadi" wrote in message ... Help pls! Need a formula to do the following: if date in range matches date in a cell then sumif function... the formula doesn't take the if fucntion relating to date in account... -ellie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple conditions
Hi,
suppose that your dates are in column A starting in row 2, the amount to be sum in column B and the day entered for what you want the sum is in cell C1 so in D1 enter =SUMPRODUCT(--(c1=A2:A100),B2:B100) change the range to fit your needs "Ellie Sarmadi" wrote: Help pls! Need a formula to do the following: if date in range matches date in a cell then sumif function... the formula doesn't take the if fucntion relating to date in account... -ellie |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple conditions
Hi,
It would help us if you showed us your formula and what you expect it to do. In general something like will work just fine: =SUMIF(A1:A19,D1,B1:B19) where A1:A19 contains dates and D1 has the date you are looking for, then sume B1:B19 for the rows where A1:A19 = D1. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Ellie Sarmadi" wrote: Help pls! Need a formula to do the following: if date in range matches date in a cell then sumif function... the formula doesn't take the if fucntion relating to date in account... -ellie |
| Reply |
| 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 | |||
Hybrid Mode
