Yes we do have the records of sales by person who belongs to each office located within the Region up to the Area:
Currently each promo's data is their own tab, 4 data tabs. Those feed into 3 tabs that show Pivot table summaries
1. The promo data
2. YTD by Region and Office
3. All months...
Currently each promo's data is their own tab, 4 data tabs. Those feed into 3 tabs that show Pivot table summaries
1. The promo data
2. YTD by Region and Office
3. All months shown by Region and Office
I keep getting stuck on what I how I want it to visually look. The best way to present the...
Hi!
I am looking for suggestions for a promotions tracker I am creating. I have a couple of sheets with tables that show the Promo Summary and then the Promo by Area/Region/Office.
I keep getting stuck on what I want to show visually. I haven't been able to find much when searching.
If...
Hi!
I am trying to create a formula that tests two cells for conditions and produces a result, but I am having issues with my formula.
This is the formula I created that I am having trouble with:
=IF(AND($C6=4,$F6=100-104.9),500,0)
Here are a few of the scenerios I am working with.
If...