jaadu
New member
- Joined
- Nov 13, 2011
- Messages
- 13
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2010
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(C2<0,"CREDIT",IF(C2>=0,"DEBIT","Check Amount"))
If you can help me out, I would greatly appreciate it.
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(C2<0,"CREDIT",IF(C2>=0,"DEBIT","Check Amount"))