Sumif - Sumif question

[Andrewbutler]

I have a list of columns with values in it, I am trying to count the number of occurances in one cell and Sum the occurances in another cell based on the below, something is not working properly though?

Formula used:

=SUMIF('Raw Apr - Nov 13'!BE:BE,">=10000")-SUMIF('Raw Apr - Nov 13'!BE:BE,"<20000")

Values
55,559.59
1,522.16
149,352.83
55,365.67
5,910.34
207,092.36
53,956.32
55,483.96
20,386.35
25,186.91
634.20
258,413

Criteria
0 - 10k
10 - 20k
20k - 30k
30k - 40k
40k - 50k
50k+

[Ron Coderre]

This formula returns the sum of values greater than or equal to 10,000 and less than 20000:

=SUMIF('Raw Apr - Nov 13'!BE:BE,"<20000")-SUMIF('Raw Apr - Nov 13'!BE:BE,"<10000")

This formula returns the count

=COUNTIF('Raw Apr - Nov 13'!BE:BE,"<20000")-SUMIF('Raw Apr - Nov 13'!BE:BE,"<10000")

Is that something you can work with?

[mcmahobt]

Without providing a sample workbook, or what is actually going wrong with your calculation (wrong result vs. expected?), I would recommend using formula evaluator to try and track your problem. Use ALT+T+U+F to open.

Hope this helps.

[Jonmo1]

Or

=SUMIFS('Raw Apr - Nov 13'!BE:BE,'Raw Apr - Nov 13'!BE:BE,">=10000",'Raw Apr - Nov 13'!BE:BE,"<20000")
and
=COUNTIFS('Raw Apr - Nov 13'!BE:BE,">=10000",'Raw Apr - Nov 13'!BE:BE,"<20000")

[Andrewbutler]

Perfect Ron Perfect!