BlueRhinos
Board Regular
- Joined
- Aug 31, 2007
- Messages
- 83
I have written a Sumif Formula for the purpose of adding cells within a range that meet multiple criteria. The formula syntax was copied from a MR Excel forum and the parameters were updated in accord with my spreadsheet. The resulting value is 0 as opposed to #NA, which indicates the formula syntax is correct?? I can accomplish my desired result by creating multiple counif formulas and summing them up, but wanted to streamline the process. Why is this formula performing the math?