Can you use the COUNTIF function with another sum formula?
Hi
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, "hiviz 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.
TIA 😊
Answers

This should do it:
SUMIFS(Quantity:Quantity, Item:Item, 'hiviz polo shirt", Quantity:Quantity, >0)

Hi David
Thank you for your response. That didn't actually work, but you gave me an idea so I tweaked your formula slightly and it returned the correct value. I amended it to the following:
=SUMIFS(Quantity:Quantity, Quantity:Quantity, >0, Item:Item, "HiViz Polo Shirt")
Kind regards
Mel

Good deal. It appears the part that didn't work was the capitalization in the HiViz descriptor.
Either way, glad it is working for you now.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!