Posted to microsoft.public.excel.worksheet.functions

LAM

external usenet poster

Posts: 8

Autosum and formulas that result in text

I am using the Autosum command to sum a range of cells. The cells with
conditional formating similar to the formula below are not included in the
autosum. Can you tell me why?

=IF(C17=12,"2.0",(IF(C17=9,"1.5",IF(C175,"1",IF (C170,"0.5","0")))))

Thanks,
LAM

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
AutoSum and text	SueG	Excel Worksheet Functions	3	July 7th 09 01:31 PM
Show formulas result + text directly	veggies27	Excel Worksheet Functions	3	March 20th 08 03:27 AM
Where is the result after I do an autosum function?	PatS	Excel Discussion (Misc queries)	14	January 20th 08 05:22 PM
Formulas - SUMIF but with a text not number result?	Lindy	Excel Discussion (Misc queries)	1	March 30th 07 05:30 AM
How do I autosum text?	staysee	Excel Worksheet Functions	2	September 20th 05 12:42 AM

All times are GMT +1. The time now is 12:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us