Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Banana
 
Posts: n/a
Default Need to create a SUM for data in a row of cells containing IF fun.

I have a row of cells with IF functions that return a number in each cell. I
have a SUM total at the end of the row which returns a zero valuve! Why is
the SUM function returning a zero value?

  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Likely the IF functions are returning text digits rather than numbers.

Jerry

Banana wrote:

I have a row of cells with IF functions that return a number in each cell. I
have a SUM total at the end of the row which returns a zero valuve! Why is
the SUM function returning a zero value?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How can I create custom format cells for Ohms(Ω)?? GlanzaV Excel Worksheet Functions 1 February 15th 05 06:10 PM
How to create mandatory cells in a worksheet prakash Excel Worksheet Functions 0 January 15th 05 03:03 PM
how do I create a formula to seperate name into two cells (last, . jobby55 Excel Discussion (Misc queries) 2 January 13th 05 06:00 AM
how can i create a formula or format the cells so the answer is a. jenniss Excel Discussion (Misc queries) 5 January 6th 05 05:50 PM
how do you create drop down menus for individual cells in excel? Frosty1 Excel Worksheet Functions 2 November 16th 04 12:02 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"