Hi, I've created a very simple description template of what I'm trying achieve. The number sold looks up from the sales team Total for a quarter & then column F works out the stock sold as a % of the total stock held. What I need to work out is how do I get fields that have no data in them Q3 & Q4 to return a blank field so that the total % F9 isn't calculating the result by dividing the toal by 4 when there is only 2 quarters of data. (I hope that makes sense)
Last edited by mgmerv; 06-24-2015 at 11:41 AM.
One way
In M13 copied down
=IF(COUNT(J13:L13)>0,SUM(J13:L13),"-")
In F5 copied down
=IF(ISNUMBER(E5),(E5/D5),"-")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Put this formula in F5:
=IF(E5=0,"",E5/D5)
then copy down to F8.
Hope this helps.
Pete
=averageif(f5:f8,">0")
Thanks very much they are all very useful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks