How to do an is numeric within a SUMIF

Posted on 2012-09-22
Last Modified: 2012-09-22
Hi all

I have the below formula where the ISNUMBER parameter is not working.
=SUMIF($AA$6:$AA$10000, ISNUMBER($Z$6:$Z$100000),$Z$6:$Z$100000)

Question:  How to pull off a SUMIF where instead of testing the AA column for a specific string ("cash", "not paid"), test it to see if the corresponding AA cell is numeric?  (i.e. a check number)

Thanks in advance.
Question by:Jim Horn
    LVL 50

    Accepted Solution

    You seem to be testing column Z not column A in that formula? - in any case I don't think you can do that with SUMIF, try this formula


    That will sum column Z if column A is a number, is that what you need?

    regards, barry
    LVL 65

    Author Closing Comment

    by:Jim Horn
    Changed A to AA, worked like a charm.  Thanks.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 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

    16 Experts available now in Live!

    Get 1:1 Help Now