Good Morning,
I am having a hard time figuring out a formula that will give me a count on certain products on a invoice. I normally try to do my best to research but I do not know where to begin to look.
Each morning I run a report and manually count cell phone activations by Data plan to add into my MTD Report for our sales reps. This is a very time consuming process and I would like to find a more efficient way of adding up activations.
Here is how the report is laid out. I'm trying to figure out how to total up activations by data plan (smart, unlimited plan). If a invoice contains "activation rebate sku" and "unlimited plan" the formula would return a total for unlimited plans.
Is this something that can be done?
Report_Capture.JPG
Bookmarks