Forum Discussion
nmbalmforth
Nov 17, 2020Copper Contributor
Help Categorizing Data
Hello! I'm sure that I have the verbiage wrong but I need help figuring out how to categorize some data. I've attached some samples below. I fill out a weekly report that tracks how often produc...
SergeiBaklan
Nov 17, 2020Diamond Contributor
Depends on which calculation you'd like to do. For example, count number of Brand A products in weekly report is like
=SUM(COUNTIF(BrandA list,weekly list))nmbalmforth
Nov 17, 2020Copper Contributor
SergeiBaklan Thank you for the help!
When I try this I keep getting a zero for the total. Any suggestions?
Thank you!
- SergeiBaklanNov 18, 2020Diamond Contributor