Question

Forms SUMIFS not behaving

Forms

Updated August 23, 2018

asked on August 16, 2018 • Show version history

I have a check box that when checked shows a table.

The Sum total of all Amounts in this table populate in a Total Labor field.

Variable = Labor.Amount

The calculation for the Total_Labor field needs to only SUM when the Table is shown. So I am using a SUMIFS statement on Total_Labor to Only SUM when the Billable_Items.Labor="True"

But it is not summing when it is checked or removing when unchecked.

The Calculation being used is:

=SUMIFS(Labor.Amount,Billable_Items.Labor="True")

0 0

Answer

SELECTED ANSWER

replied on August 23, 2018

Hi Chase,

Since you only have one criterion, what about this calculation:

=IF(Billable_Items.Labor, SUM(Labor.Amount), "0")

Hope this helps!

1 0

Replies

replied on August 22, 2018

Seeing if anyone has any ideas yet.

0 0

replied on August 23, 2018

That works perfectly! Thank you.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms SUMIFS not behaving

Answer

Replies

Sign in to reply to this post.