Ok this is grinding my gears and I am sure it is a simple answer. The formula =SUMIF(A:A,A:A>.1:A:A<5.9,A:A) For the criteria of this equation I am trying to specify the range of .1 to 5.8 and if that is met, to then sum them up. I know this to be the issue A:A>.1:A:A<5.9 but how is it fixed. Hope this is clear.
Last edited by indeepdoD; 09-27-2012 at 02:11 PM. Reason: asked to
Suggest you change the title of this thread as it is too non-descript.
Use =SUMIFS(A:A,A:A,">.1",A:A,"<5.9")
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
@ Pauleyb,
It works on my side!
Please amend thread title as per forum rules
Sorry about that fist time poster. I dont know if this title is any better. I will plug this solution in and see if it works. Thanks for the help.
That is it thany you very much.
Much better thxOriginally Posted by indeepdoD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks