Results 1 to 5 of 5

Trying to produce blanks cells for some alpha numeric charatcters and not others

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    106

    Trying to produce blanks cells for some alpha numeric charatcters and not others

    I have a large spread sheet. The values in the column "O" I am referencing are M, T, numbers, and blank cells. I want to keep the T and number values in Column D, but want the M to be a blank cell and the blank cell to remain blank. The following formula does well except it is assigning both T and M as a blank cell.

    =IF(COUNTIFS($o$4:$o$34,">=0",$n$4:$n$34,$A$1,$k$4:$k$34,$A4)>=1,SUMIFS($o$4:$o$34,$n$4:$n$34,$A$1,$k$4:$k$34,$A4),"")

    Thanks in advance for any help that you can provide!
    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. Sum cells that contain alpha and numeric
    By Hammer1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-04-2011, 09:41 PM
  2. Replies: 2
    Last Post: 06-18-2010, 05:10 PM
  3. using if then functrion with alpha numeric cells
    By JEllison in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2007, 03:43 PM
  4. [SOLVED] Sorting Cells With Alpha Numeric Values
    By 69-er in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-31-2006, 01:28 PM
  5. convert cells containing alpha to numeric
    By ezu in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-09-2005, 06:06 PM

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