Can you use the COUNTIF function with another sum formula?


I was wondering if someone might be able to help me please. I have a sheet that lists PPE items, i.e. Item, size, quantity taken etc. I have used COUNTIF to identity what has been taken using the following:

=COUNTIFS(Item:Item, "hi-viz polo shirt", Quantity:Quantity, >0)

Which returns the number of rows that have the item listed, however I also need it add up the quantities as well. For example, at the moment it shows there are 6 entries in the form which there are but I also need it to add up the quantities as the quantity taken is higher, i.e. six entries but 10 shirts taken.

Is there a way to do this? Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!