SUM IFS in Pivot Table

[#1]

Hi,

the below formula does not sum the Or 'Updated transaction',

I need both New and Updated transactions to be summed, right now only the New transactions part work.

Any ideas why?

SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or 'Updated transaction', AMOUNT)))

[m_woolf · Accepted solution]

Try:

SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or ([TRANSACTION STATUS]='Updated transaction', AMOUNT)))

[#3]

thanks!