| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add date condition
I am using this formula to sum amount.
=SUMIF(H2:H82;"=c";G2:G82) H column including amount G column including amount's nature D or C (Debit, Credit) Now I want to add another condition, I want to specify date. How I can adjust the formula by adding date condition, for example I want only Feb 2008 Amount. Please help me -- MFS22 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add date condition
=SUMPRODUCT(--(H2:H82="c");--(TEXT(F2:F82,"mmmyyyy")="Feb2008");G2:G82)
-- __________________________________ HTH Bob "MFS" wrote in message ... I am using this formula to sum amount. =SUMIF(H2:H82;"=c";G2:G82) H column including amount G column including amount's nature D or C (Debit, Credit) Now I want to add another condition, I want to specify date. How I can adjust the formula by adding date condition, for example I want only Feb 2008 Amount. Please help me -- MFS22 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add date condition
You'll need SUMPRODUCT. See countless examples in this newsgroup.
-- David Biddulph "MFS" wrote in message ... I am using this formula to sum amount. =SUMIF(H2:H82;"=c";G2:G82) H column including amount G column including amount's nature D or C (Debit, Credit) Now I want to add another condition, I want to specify date. How I can adjust the formula by adding date condition, for example I want only Feb 2008 Amount. Please help me -- MFS22 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtain Value from a Max Date Condition | Excel Discussion (Misc queries) | |||
| Latest date with condition | Excel Worksheet Functions | |||
| How to valid the date with given condition? | Excel Discussion (Misc queries) | |||
| count between two date with one more condition | Excel Worksheet Functions | |||
| Calculate a date or key a date on condition | Excel Discussion (Misc queries) | |||
Linear Mode
