LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Adding Only Positive Numbers

I have been looking around and found solutions to adding only positive
numbers in a range however, if I am trying to add numbers that are not
next to eachother but actually every other cell, everytime that I
select the 4 cells a "," is added between each messing up my formual.
ie. =SUMIF(H3,J3,L3,N3,0), how would I do that only adding the numbers
that are positive?

Thanks for the help, hopefully I explained it good enough.

 
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
Numbers not adding together correctly Andy Bleese Excel Worksheet Functions 0 November 3rd 06 03:08 PM
How to switch negative numbers to positive numbers in Excel ? amashmallow888 Excel Worksheet Functions 2 September 25th 06 06:34 AM
Displaying all numbers as positive TeddyTash Excel Worksheet Functions 0 September 22nd 06 11:06 AM
Adding to a column of numbers Colleen Excel Worksheet Functions 1 January 4th 06 06:26 AM
Find Median of Positive numbers only in Range MichaelC Excel Worksheet Functions 4 June 24th 05 03:06 AM


All times are GMT +1. The time now is 05:52 AM.

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

About Us

"It's about Microsoft Excel"