sblg43
New Member
- Joined
- Jan 25, 2005
- Messages
- 2
I am a self taught computer guy with limited excel experience. What I am trying to do is set up a "sales journal" showing our daily sales activity, weekly sales activity and monthly sales activity. I set it up but I need to know how to compare some cells for accuracy.
My "journal" has a break-down of pre-tax sales (in one cell) then sales tax (in one cell) with the SUM of the two in a third cell. No problems there. However, I then have the sales broken down into Cash, Elan, Discover and Amex. What I need to do is make sure that the combined totals of Cash, Elan, etc... is equal to the SUM of the pre-tax plus sales tax cell.
I hope this makes sense. Can anybody show me a formula or function to compare these totals and let me know if they don't match?
Thanks
Scott
My "journal" has a break-down of pre-tax sales (in one cell) then sales tax (in one cell) with the SUM of the two in a third cell. No problems there. However, I then have the sales broken down into Cash, Elan, Discover and Amex. What I need to do is make sure that the combined totals of Cash, Elan, etc... is equal to the SUM of the pre-tax plus sales tax cell.
I hope this makes sense. Can anybody show me a formula or function to compare these totals and let me know if they don't match?
Thanks
Scott