Results 1 to 3 of 3

Problem with Sumif, and blank cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    London, England
    MS-Off Ver
    Excel 365
    Posts
    13

    Problem with Sumif, and blank cells

    Hi All

    I need help with below please,

    I am trying to do sumif on below

    A B C Total that I need to achieve
    -520 Check [blank] -520
    -321 Check -321 0


    Criteria
    Sumif B2 have "Check" add A2 then -C2 Problem is C2 although shows no value, there is formula that returns Blank Value.

    Please see attached file.

    Thank you for your help

    Chirayu
    Attached Files Attached Files
    Last edited by Chirayu Amin; 08-06-2009 at 05:12 AM.

Thread Information

Users Browsing this Thread

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

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