CountIFS/SumIFS Question | Microsoft Community Hub (opens in new tab)

Hello everyone,I'm working with a lot of data, and trying to find a way to add quantities already in the sheets but spread out over 500 or more rows. I'm not able to change how the data is delivered to me, as it's a downloaded file from a 3rd party.Here's a sample of what I'm looking at:ABCDPlain Bagel 7Plain BagelBagel SpreadsCream Cheese 5Plain BagelBagel SpreadsButter 2Plain BagelToasted/WarmedYes Toasted/Warmed 7Double EspressoFood SelectionPlain Bagel w/ Cream Cheese4Hot Chai LatteFood S...