Formula in a dropdown menu

cocog

This is what I am trying to do...

I need the total of "amount Due" if "invoice" is selected. And the Total of "Amount Due" if "On Order" is selected. I would like for that info to populate at the top

Help!

Devin Lee

Hey @cocog,

These two formulas should work for that

Invoiced

=SUMIF([PO Status]:[PO Status], "Invoiced", [Amount Due]:[Amount Due])

On Order

=SUMIF([PO Status]:[PO Status], "On Order", [Amount Due]:[Amount Due])

Devin Lee

Hey @cocog,

These two formulas should work for that

Invoiced

=SUMIF([PO Status]:[PO Status], "Invoiced", [Amount Due]:[Amount Due])

On Order

=SUMIF([PO Status]:[PO Status], "On Order", [Amount Due]:[Amount Due])

cocog

Yes!! Thank you so much!!