If Formula

Samuel Dowdy Jr.

Need help saying add if this formula = 0 then it needs to =[Paid ($)]@row

=SUMIFS({Material Requisition - Inv Amount}, {Material Requisition - Anticipated Year}, Year@row, {Material Requisition - Anticipated Month}, [Month - Count]@row, {Material Requisition - Location}, Data@row)

BullandKhmer

And if it doesnt =0?

Samuel Dowdy Jr.

If it does = 0

Kelly Moore

Hey @Samuel Dowdy Jr.

I think you are asking for this?

=IF(SUMIFS({Material Requisition - Inv Amount}, {Material Requisition - Anticipated Year}, Year@row, {Material Requisition - Anticipated Month}, [Month - Count]@row, {Material Requisition - Location}, Data@row)=0, [Paid ($)]@row, SUMIFS({Material Requisition - Inv Amount}, {Material Requisition - Anticipated Year}, Year@row, {Material Requisition - Anticipated Month}, [Month - Count]@row, {Material Requisition - Location}, Data@row))

Does this work for you?

Kelly