Results 1 to 7 of 7

Sum a column based on a specific value range

Threaded View

indeepdoD Sum a column based on a... 09-27-2012, 11:47 AM
Pauleyb Re: Formula Help 09-27-2012, 12:08 PM
Winon Re: Formula Help 09-27-2012, 12:15 PM
Pepe Le Mokko Re: Formula Help 09-27-2012, 12:52 PM
indeepdoD Re: Sum a column based on a... 09-27-2012, 01:51 PM
indeepdoD Re: Sum a column based on a... 09-27-2012, 02:11 PM
Pepe Le Mokko Re: Sum a column based on a... 09-27-2012, 02:29 PM
  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Bristol,Wisconsin
    MS-Off Ver
    Excel 2007
    Posts
    5

    Sum a column based on a specific value range

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1