Results 1 to 21 of 21

Adding numbers ignoring text & negatives

Threaded View

CLDr Adding numbers ignoring text... 09-10-2022, 08:00 AM
JohnTopley Re: Adding numbers ignoring... 09-10-2022, 08:18 AM
CLDr Re: Adding numbers ignoring... 09-10-2022, 08:50 AM
HansDouwe Re: Adding numbers ignoring... 09-10-2022, 08:50 AM
CLDr Re: Adding numbers ignoring... 09-10-2022, 08:55 AM
HansDouwe Re: Adding numbers ignoring... 09-10-2022, 09:01 AM
CLDr Re: Adding numbers ignoring... 09-10-2022, 12:07 PM
Pepe Le Mokko Re: Adding numbers ignoring... 09-10-2022, 10:01 AM
JohnTopley Re: Adding numbers ignoring... 09-10-2022, 11:24 AM
CLDr Re: Adding numbers ignoring... 09-10-2022, 12:11 PM
CLDr Re: Adding numbers ignoring... 09-10-2022, 12:08 PM
HansDouwe Re: Adding numbers ignoring... 09-10-2022, 12:40 PM
JohnTopley Re: Adding numbers ignoring... 09-10-2022, 01:51 PM
CLDr Re: Adding numbers ignoring... 09-12-2022, 05:07 AM
HansDouwe Re: Adding numbers ignoring... 09-12-2022, 05:50 AM
CLDr Re: Adding numbers ignoring... 09-12-2022, 03:40 PM
JeteMc Re: Adding numbers ignoring... 09-13-2022, 07:19 AM
CLDr Re: Adding numbers ignoring... 09-13-2022, 10:00 AM
Phuocam Re: Adding numbers ignoring... 09-13-2022, 08:09 AM
CLDr Re: Adding numbers ignoring... 09-13-2022, 10:00 AM
JeteMc Re: Adding numbers ignoring... 09-13-2022, 12:53 PM
  1. #1
    Registered User
    Join Date
    09-10-2022
    Location
    UK
    MS-Off Ver
    Mac
    Posts
    10

    Adding numbers ignoring text & negatives

    I wish to add a column of numbers with 2 complications: 1. some cells contain negative numbers which I want to treat as positive numbers and 2. some cells may also contain text which I want to ignore, but still add the number in the cell (in which case text is always the same word - online). I have a formula to treat the negative numbers as positive ( =SUM(ABS(T3:T19)) ), but can't work out how to also include the numerical data in cells with text. In row '11' below I have shown the results I would like to generate.

    Any help appreciated! Thx
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trying to add a column of numbers, but ignoring negatives
    By Lord Waste in forum Excel General
    Replies: 5
    Last Post: 04-07-2009, 06:43 AM
  2. Sort ignoring negatives and positives
    By bangbanjo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1