Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help for a formula using two conditions
Hi. Can anybody help me with a formula based on two conditions.
I have a spreadsheet with various columns (example shown below). Month Customer Contract Type Contract Value Yr Value Apr 04 xxx New £10,000 £2,000 Apr 04 xxx Upgrade £2,000 £500 May 04 xxx New £15,000 £5,000 I need to be able to total the 'Yr Value' for 'New' contracts in 'Apr 04'. In the example above, I expect to get £2,000 for Apr 04 and £5,000 for May 04. This could be more complicated as the spreadsheet I want to put the formula in is different from where the information is. I have tried various formula with no success. Below is an example of one that I have tried. =SUM(IF(('[New Revenue 04_05.xls]New Revenue'!$A$2:$A$300="Apr 04")*('[New Revenue 04_05.xls]New Revenue'!$D$2:$D$300="New"),'[New Revenue 04_05.xls]New Revenue'!$K$2:$K$300)) Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Concatenating two conditions in a "IF" Formula. | New Users to Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |