Posted to microsoft.public.excel.worksheet.functions

Jon the Contractor Jon the Contractor is offline

external usenet poster

Posts: 1

Formula/Sum Question

If i have a dollar value in cell a1 and no value in cell a2 and the sum
formula in cell a3, a3 returns the value of cell a1 since it is the only cell
with a value in it. Is there a formula that will sum a1 and a2 only when
they both have values in them?

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
formula question	JaneSmith	Excel Worksheet Functions	2	June 18th 08 05:22 PM
MID formula question	Brian	Excel Worksheet Functions	2	October 24th 07 02:50 PM
Formula Question	PhxlatinoboiÂ®	Excel Discussion (Misc queries)	3	June 1st 07 01:14 AM
Formula Question	Confused Excel User	Excel Worksheet Functions	0	October 13th 06 03:55 PM
Newbie Question - Subtraction Formula Question	[email protected]	Excel Discussion (Misc queries)	3	May 5th 06 05:50 PM

All times are GMT +1. The time now is 08:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us