I want to add to my existing formula that works

[DNapoli]

=IF(AND(MONTH(N3)=C3,YEAR(N3)=D3 ,H3,0)+AV3+AY3 (This formula works)

I want to add to the below as part of the top formula

If (And(Month(AQ3) =C3, Year (AQ3)=D3, H3,0 + AS3+AV3+AY3

Basically I am asking if the original invoice is in October and the add the original invoice amount H3 to AV3 + AY3 which is the credit and revised invoice.

Now I want to add the 2nd statement if the revenue is being re-allocated to another invoice in October add it to the formula as well.

Basically it would be two If And's in one statement.

 

[dreid1011]

Can you provide some sample data and expected results for each formula and as a whole? Also, did you retype those formulas here or copy/paste? I'm just curious, because they're missing a closing ")" and you said it works. So, I'm going to assume you just retyped them and forgot a ")".

 

[FDibbins]

Maybe this?

=IF(AND(MONTH(N3)=C3,YEAR(N3)=D3 ,H3,0)+AV3+AY3 + If (And(Month(AQ3) =C3, Year (AQ3)=D3), H3,0 + AS3+AV3+AY3

Also, are you really sure that 1st part works?
Looks to me like you did not close your AND properly?
IF(AND(MONTH(N3)=C3,YEAR(N3)=D3 ,H3,0)+AV3+AY3