Excel Help (Again)

PearlJamaholic

You guys seem to be better help than Google when I get stumped with Excel stuff so I have another one, and it seemed so easy, 3 hours later it doesnt feel so simple now.

What I would like to do is do a SumIf that uses greater than 3 and equal to or less than 5. I have it figured out for numbers less than 3,
SUMIF(Cell,"<3")

and greater than 5
SUMIF(Cell,">5")

So I figured the middle section would be
SUMIF(Cell,">3",Cell,"<=5")

But I tried that along with countless other variations based on what I found on Google and none of them worked. So where am I messing up here?

hostis

not sure what you are needing the sum if to show as without the rest of the cells and calculation it would be difficult to specific exactly. is it referencing just one cell above or a calculated cell?

what I would recommend is to join a website called mrexcel.com. there are some fantastic excel experts there and will always help you fully.

81

you can't do the conditions within the sumif...

what i would do is...throw a column in beside your data set that was

if(or(cell<3,cell>5),"yes","no")


then i would do the sumif off that column

sumif(new column,"yes",column to sum)

81

or you can do something like this


=SUMIF(H:H,"<3",I:I)+SUMIF(H:H,">5",I:I)

PearlJamaholic

Alright thanks, I'll try these later. Sure one of them will work! Seems I was trying to do something crazy...