Question on Sumif

[rices]

I want to sum bsed on the range of data

Example

Data
75
46
98
125
89
69
50
79
I want to sum the data if is beween 60 and 89

I tried sum if but i could get it to work

Any ideas?

Thanks

 

[MrKowz]

Try:

=SUMIF(A:A,"<89")-SUMIF(A:A,"<60")

 

[T. Valko]

I want to sum bsed on the range of data

Example

Data
75
46
98
125
89
69
50
79
I want to sum the data if is beween 60 and 89

I tried sum if but i could get it to work

Any ideas?

Thanks

Try this...

With your data in the range A2:A9...

Use cells to hold the criteria:

• C2 = 60
• D2 = 89

=SUMIF(A2:A9,">="&C2)-SUMIF(A2:A9,">"&D2)

 

[rices]

i forgot part becaue i hit enter too fast

I want to sum data on another column based on the data in the one column

Here is my data:

34 80
39 106
35 30
62 79
55 66
53 28
50 105
16 64
46 42
17 107

I want to sum column a based on the whether column b is between 60 and 89

 

[T. Valko]

i forgot part becaue i hit enter too fast

I want to sum data on another column based on the data in the one column

Here is my data:

34 80
39 106
35 30
62 79
55 66
53 28
50 105
16 64
46 42
17 107

I want to sum column a based on the whether column b is between 60 and 89

Try it like this...

=SUMIF(B2:B11,">="&C2,A2:A11)-SUMIF(B2:B11,">"&D2,A2:A11)

 

[Aladin Akyurek]

i forgot part becaue i hit enter too fast

I want to sum data on another column based on the data in the one column

Here is my data:

34 80
39 106
35 30
62 79
55 66
53 28
50 105
16 64
46 42
17 107

I want to sum column a based on the whether column b is between 60 and 89

Either...

Control+shift+enter, no just enter:

=SUM(IF($A$2:$A$11>=60,IF($A$2:$A$11<=89,$B$2:$B$11)))

Or...

Just enter:

=SUMPRODUCT($B$2:$B$11,--($A$2:$A$11>=60),--($A$2:$A$11<=89))

Or...

Just enter if on Excel 2007 or later:

=SUMIFS($B$2:$B$11,$A$2:$A$11,">=60",$A$2:$A$11,"<=89")

 

[rices]

It worked

thanks to both for the quick answers