I'm using the following formula.
=SUMIF($G$7:$G$31,A122,C122)
The Range looks as follows.
1
3
5
7
The Criteria is a cell with the value of: 5
The Sum Range is one cell with the value of: 50,000.00
When I open the Function Arguments window it tells me
RANGE = {1,3,5,7}
CRITERIA = 5
SUM_RANGE = 50000
But the FORMULA RESULT is 64000
I can not determine where the extra 14000 is coming from. I have tried everything I know to solve this. FORMULA AUDITING, EVALUTATE FORMULA, etc. HELP!!!!
Bookmarks