Aladin Akyurek said:
Nath said:
i am trying to use this formula, but works with only the first 2 conditions.
=SUM(IF(('BB Data Files 0506.xls'!Ren_Date > D10-30)*('BB Data Files 0506.xls'!Ren_Date < D10+1)*('BB Data Files 0506.xls'!Pack="Waived"),'BB Data Files 0506.xls'!ValueR))
Any help will be greatly apprciated
=SUM(IF('BB Data Files 0506.xls'!Ren_Date > D10-30,IF('BB Data Files 0506.xls'!Ren_Date < D10+1,IF('BB Data Files 0506.xls'!Pack="Waived",'BB Data Files 0506.xls'!ValueR))))
which needs to be confirmed with control+shift+enter, not just with enter.
If this does not yield the desired outcome, try to specify the named ranges in detail.
Thanks for the suggestion. Unfortunately it did not work.
The rages are
Multi column range with 26 columns running to 2500 rows. The formula concerns 2 columns
1. Renewal Date - Date of renewal
2. Pack - check if the charges are waived
3. Renewal Amount - Sum values in this column
i am trying to sum data to sum data that falls within 2 dates and where the renewal charges are waived.
i hope this will enable you to come up with a solution. Thanks in advance