Formula Calculation Problems

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Ran into a situation where a spreadsheet is not pulling
the correct data from another sheet in the same
workbook. The formula is correct but as I understand
there might be a max limit on how many formulas are used
to pull info and I may have exceeded the max amount?

I'm using a daily worksheet that rolls into a total daily
from 6 different sources, i.e. 6 sales people's data
rolls into a daily total then I pull those daily totals
by category into a month at a glance report by day.

I have previous versions of this report that work fine
the difference in this one is I used the "$" function to
lock the formulas since I needed to cute and past 35 days
of calculations onto 1 sheet.

Any feedback would be greatly appreciated.
 
Hi Adam
you may post your formula - otherwise quite difficult to say what has
gone wrong. also describe with this formula and some sample data what
result you got (and what you expected).
 
Adam

Post some information of what data you have and what formulas you are using.

Andy.
 
Back
Top