I have the following formula which I have validated and it works:



=SUMIFS(Holdings!N:N,Holdings!A:A,'Trial Balance'!C3)-SUMIFS(Holdings!P:P,Holdings!A:A,'Trial Balance'!C3)

I now want to add some more to it, I think that an IF & AND statement is correct.

=IF(AND(G3="105",D3="Composite"),SUMIFS(Holdings!N:N,Holdings!A:A,'Trial Balance'!C3)-SUMIFS(Holdings!P:P,Holdings!A:A,'Trial Balance'!C3),0)

But this is returning a value of ZERO. If I switch it so that the SUMIFS is the value if false & use a ZERO for value if true the formula works.

Is there something wrong with my IF AND statement?

Once I get the formula to work for the true side instead of zero for the false it will become a nested formula to for other "Numbers" in G3.

Thanks Everyone!

Probably remove the double quotes around the value for G3 like G3=105

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

awesome! So if I understand this, quotes are only needed around actual text, if it a hard reference of a number it is not?

Exactly. If it really is text double quotes are needed G3="text" needs the quotes otherwise, no joy.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Great! Thank you!