S
SteveB
I'm trying to show the % of billing is contributed by the top 3 ranked
accounts, so have used a formula which I've used successfully on another
sheet (=SUM(IF(list of ranked data<4,billing amounts,0))/Total Billing). The
cell shows 0% but when I click the fx button it gives the answer as 76%
(which is correct) but it just won't show the result in the cell!
accounts, so have used a formula which I've used successfully on another
sheet (=SUM(IF(list of ranked data<4,billing amounts,0))/Total Billing). The
cell shows 0% but when I click the fx button it gives the answer as 76%
(which is correct) but it just won't show the result in the cell!