I am trying to return financial data (which is seperated by month), on a YTD basis (but also based on other variables within the database).

My formula is as follows:
=SUM(IF('BI P&L Download Mth by Mth'!$D$30:$D$65536=CONCATENATE('Set Up'!$B$4," ","YTD"),IF('BI P&L Download Mth by Mth'!$E$30:$E$65536='Set Up'!$B$1,IF(AND('BI P&L Download Mth by Mth'!$G$30:$G$65536='Set Up'!$B$2,'BI P&L Download Mth by Mth'!$G$30:$G$65536='Set Up'!$B$6),IF('BI P&L Download Mth by Mth'!$C$30:$C$65536=$A8,'BI P&L Download Mth by Mth'!$I$30:$I$65536,0),0))))*1000

The portion in red is the problem, where I want it too read 2 different months and return the result for both months from the database.

For simplification, I will use a easier example, which will help. (This from exceldigest.com)

In the example below we want to sum up the total sales for “John” in quarter 2 (Q2). i.e. our criteria is “John” in column B and “Q2″ in column C. We will use the following formula for this purpose:

{=SUM(IF($B$2:$B$17=”John”,IF($C$2:$C$17=”Q2″,$D$2:$D$17,0),0))}

This formula will give us a result of 9547 (summing sales in the yellow rows).
EXCEL.gif

Now however I want to be able sum Johns data for Q1 AND Q2.

Please can someone help?