to change =SUMIFS for negative values.

[DRG1978]

Hi All,

I'm using the following formula but want to add the criteria to show only negative values.

Can you please let me know how the new formula will have to look?

=SUMIFS('Pivot -'!G:G,'Pivot -'!B:B,B2,'Pivot -'!C:C,"NHR TWS Transaction",'Pivot -'!D:D,"A*PAINT-ORD",'Pivot -'!A:A,A2)+ SUMIFS('Pivot -'!G:G,'Pivot -'!B:B,B2,'Pivot -'!C:C,"NHR TWS Transaction",'Pivot -'!D:D,"A*QC-PAINT-READY*",'Pivot -'!A:A,A2)

Let me know if i need to provide more details.

Thank you very much!!

 

[AlanY]

will this work for you?

=[COLOR="#FF0000"]min(0,[/COLOR]SUMIFS('Pivot -'!G:G,'Pivot -'!B:B,B2,'Pivot -'!C:C,"NHR TWS Transaction",'Pivot -'!D:D,"A*PAINT-ORD",'Pivot -'!A:A,A2)+ SUMIFS('Pivot -'!G:G,'Pivot -'!B:B,B2,'Pivot -'!C:C,"NHR TWS Transaction",'Pivot -'!D:D,"A*QC-PAINT-READY*",'Pivot -'!A:A,A2)[COLOR="#FF0000"])[/COLOR]

 

[DRG1978]

Thank you very much AlanY!!

Have a nice day!!

 

[AlanY]

you're welcome