Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text
After reading a few websites I find that SUMIF won't cut it for multiple
critera. However it appears SUMPRODUCT may do it, but unsure how I achieve what I need with SUMPRODUCT. Below is the actual table I have in my excel sheet. I would like to sum the column RENT/MTH (which is a calculated field RENT/WK * 4) if the TYPE = NEW and also if the START DATE is <= to a date in another field (lets us say in field B6). Pay/Wk Pay/Mth Rent/Wk Rent/Mth Start Date Type $200.00 $866.66 $106.00 $459.33 31/08/2005 NEW $210.00 $909.99 $138.00 $598.00 31/08/2005 OLD $200.00 $866.66 $167.00 $723.66 31/08/2005 BEST Can someone help with development of the formula? Thanks in advance. James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions |