SUMIFS formula with the use of "*" in the criteria and separate use of ISNUMBER

SUMIFS formula with the use of "*" in the criteria and separate use of ISNUMBER

Hi:

Referring to the attached excel file (Excel 2010 version), I have 2 questions regarding formulas for some data I am reviewing.

1. SUMIFS formula with the use of "*" in the criteria. I can get this to work with 2 separate SUMIF formulas, but it does not work in one SUMIFS formula.

2. Use of ISNUMBER. The formula listed below is from cell D3 in the attached file. Basically, column C has #s, but in case I enter a letter or word in column C, I want column D to to tell me to "Check Amount", instead of Credit or Debit. I believe ISNUMBER could do the trick, but I could not get it to work:
If you can help me out, I would greatly appreciate it.

Question 1 :As you are using a OR logic, you cannot use SUMIFS which is an AND logicView attachment Excel questions for SUMIFS and ISNUMBER.xlsx

in your formula the TRUE-part is "CREDIT" and the FLASE-part (already" >=0") can only get the "DEBIT" and can never become FALSE!

the correct formula is (first checking if the input is valid):


The easiest way to get the sum of both is the formula "=B60+B61" in your excel file.