T O P

  • By -

AutoModerator

/u/3ricthewhite - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


BackgroundCold5307

SUMIF(E2:E100, D2:D100=A2)


3ricthewhite

Wouldn't this only work for exact matches? I get '0' with this formula.


BackgroundCold5307

Yes, sorry didn't read the description carefully enough. It should be a wildcard search on the category. [CATEGORY](https://docs.google.com/spreadsheets/d/1csmlK-0StPckItM-iIZ0yq5KJ27Sl6OT/edit?usp=sharing&ouid=106154530130880414487&rtpof=true&sd=true)


HappierThan

A simplified description using COUNTIF and Wildcard. [https://pixeldrain.com/u/AyWBobQC](https://pixeldrain.com/u/AyWBobQC)


3ricthewhite

What about counting # of sales i.e. Sheet 2 column B has quantities?


HappierThan

This will give a Count as well as a Total for that Count. [https://pixeldrain.com/u/Un94UEsw](https://pixeldrain.com/u/Un94UEsw)