Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 471

# How to do an is numeric within a SUMIF

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)

Jim
0
Jim Horn
1 Solution

Commented:
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

=SUMPRODUCT(ISNUMBER(\$A\$6:\$A\$100000)+0,\$Z\$6:\$Z\$100000)

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

regards, barry
0

Microsoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Changed A to AA, worked like a charm.  Thanks.
=SUMPRODUCT(ISNUMBER(\$AA\$6:\$AA\$100000)+0,\$Z\$6:\$Z\$100000)
0

## Featured Post

Tackle projects and never again get stuck behind a technical roadblock.