+ Reply to Thread
Results 1 to 2 of 2

If Cell A or B is not black then SUM

  1. #1
    Registered User
    Join Date
    10-10-2018
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1

    Angry If Cell A or B is not black then SUM

    Hello everyone,

    I am new to this forum and I severely need some help. I have been racking my brain trying to figure something out for this. I want Cell "C" to be blank unless Cell "A" OR "B" is not blank. This is what I have so far. At the moment "C" is blank unless both "A" AND "B" are not blank. Why is this acting like an "AND" function and not an "OR" function.

    =IF(NOT(OR(B5="",B20="")),SUM(E4:E15),"")


    A=B5
    B=B20
    C=current field

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: If Cell A or B is not black then SUM

    Try...

    =IF(COUNTA(B5,B20)=2,SUM(E14:E15),"")
    or
    =IF(OR(B5="",B20=""),"",SUM(E14:E15))
    Last edited by jeffreybrown; 10-10-2018 at 01:30 PM.
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 02-12-2018, 06:51 AM
  2. Fill with Black if another cell has value of Y
    By njsdca in forum Excel General
    Replies: 2
    Last Post: 10-26-2016, 12:07 PM
  3. Multiply a black cell by a factor
    By PrintingPost in forum Excel General
    Replies: 5
    Last Post: 12-29-2015, 05:45 PM
  4. can you remove the standard black cell border when clicking on cell?
    By Muzza86 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-14-2014, 03:30 AM
  5. Replies: 0
    Last Post: 09-27-2012, 11:03 AM
  6. [SOLVED] delete only black text from cells containing both blue & black text
    By london.cl.2012 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-21-2012, 10:15 PM
  7. [SOLVED] VBA for put cell C2 in overstrike/black when B2 checkbox is ticked?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2005, 11:06 AM

Tags for this Thread

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