Posted to microsoft.public.excel.misc

external usenet poster

Posts: 117

Referring to cells on a different worksheet

My workbook has two worksheets:
ALL BILLS
BY TYPE OF BILL

On the TYPE OF BILL worksheet, the values of cells
E8 = 320
E22 = 0
E36 = 0
E50 = 30

On the ALL BILLS tab, I've typed this formula:
=SUM('BY TYPE OF BILL'!E8+E22+E36+E50)

however, the result is 320 not 350.

What's wrong?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
referring to previous worksheet in workbook	Freida	Excel Worksheet Functions	9	September 29th 09 09:33 PM
formula referring to a worksheet	Nicawette	Excel Worksheet Functions	4	August 6th 09 09:54 AM
referring a worksheet	lazmanyak	Excel Worksheet Functions	1	July 23rd 05 02:55 PM
referring to other worksheet	Geetu M	Excel Worksheet Functions	2	March 29th 05 09:37 PM
Referring to Previous Worksheet - coding	Denis	Excel Worksheet Functions	7	December 10th 04 05:24 PM

All times are GMT +1. The time now is 07:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us