theColonel
New Member
- Joined
- May 31, 2012
- Messages
- 9
What I'm tring to do: I'm trying to create a worksheet that will help with ordering parts for our inventory based off previous years sales of parts. I have 4 years of data I'm basing this off of. The columns with formulas I've written are average order size, order size deviation, high month, average number of orders, average items sold per year, average dollar amount sold per year. All based off the individual years average order size, dollar amount sold, etc.
Problem: The formulas I've written seem to work fine if there was a sale in every month for the part. When there isn't a sale, the zero wreaks havoc on the formulas. I'm fairly new to excel and before going through and trying to include if's in the formulas, I was wondering if there is a way to have formulas ignore cells if there is a zero in them.
I have to present this next friday and would really like to impress. If I wasn't clear enough on the problem or you need more info on the formulas let know and I can post it.
Thanks
Problem: The formulas I've written seem to work fine if there was a sale in every month for the part. When there isn't a sale, the zero wreaks havoc on the formulas. I'm fairly new to excel and before going through and trying to include if's in the formulas, I was wondering if there is a way to have formulas ignore cells if there is a zero in them.
I have to present this next friday and would really like to impress. If I wasn't clear enough on the problem or you need more info on the formulas let know and I can post it.
Thanks