Excel Sumifs with #Value errors if blank cells in range

Posted on 2012-08-28
Last Modified: 2012-08-28

I'm having some trouble with the sumif function in excel. I have blank cells in my range so that i can select a long range. like

243      55      0      22 Blank cell blank cell, etcetera

But when i have this range it returns a #Value error.
Hope someone knows how to fix this!

Kind regards,

Question by:MarkVrenken
    LVL 31

    Accepted Solution

    Are the cells truly blank?

    Could be a formula resulting in a space (" ") or blank ("") that is throwing it out.

    Are the numbers truly numerical or are they text?

    A sample file would be good.

    Rob H
    LVL 1

    Author Comment

    I'm sorry i made a mistake. It's not the blank values that were the problem but i forgot that the criteria range and sum range must be equal. That's why i got the #value error.
    Thanks for your attempt to help me:)
    LVL 1

    Author Comment

    is this a fair way to grade? i'm fairly new to the point system.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now