Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum based on second column date
=SUMPRODUCT(--(A1:A100=DATE(2009,1,1)),--(A1:A100<=DATE(2009,3,31),
I1:I100) will sum all the vales in I1:100 when A values are between 1Jan and 31 March But you used the phase "specific currency"; do you mean the I values could have say $ and £ values and you want only one of them? That will be problematic - lets us know it this is the case. What version of Excel? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Abel" wrote in message ... Please help. I am trying to sum only specific currency vales found in column 'I' if the date foundin column 'A' falls in a specific range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum data in 1 column based on date info in another column | Excel Discussion (Misc queries) | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
Auto Fill Column with Date based on rows in other column | Excel Programming | |||
Add amounts in a column based on transaction date in another column | Excel Programming |