SUM & SUMIFS

DanielGD

I have columns named:

1. Item Description (That contains within a text (Z123)
2. Quantity
3. Received (Check Box)

Not sure if you can use SUM and SUMIFS in same formula

Looking for a result of ~~ Out of a total of (NUMBER) you have received(NUMBER).

Thanks!

Brent Wilson

@DanielGD Try this

= "Out of a total of "+ SUMIF(Description:Description, =Description@row, Quantity:Quantity) + " you have received " + SUMIFS(Quantity:Quantity, Description:Description, =Description@row, Received:Received, =1)

Brent Wilson

This would give you % received

=(SUMIFS(Quantity:Quantity, Description:Description, =Description@row, Received:Received, =1)) / SUMIF(Description:Description, =Description@row, Quantity:Quantity)