Formula Calculation Problems

[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.

 

[Frank Kabel]

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).

 

[Andy B]

Adam

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

Andy.