Results 1 to 7 of 7

SumIf only if value is above a certain number

Threaded View

micheldun SumIf only if value is above... 11-05-2012, 02:04 PM
TheExcelphile Re: SumIf only if value is... 11-05-2012, 02:10 PM
micheldun Re: SumIf only if value is... 11-05-2012, 03:43 PM
oeldere Re: SumIf only if value is... 11-05-2012, 03:54 PM
micheldun Re: SumIf only if value is... 11-05-2012, 04:00 PM
Haseeb Avarakkan Re: SumIf only if value is... 11-05-2012, 04:01 PM
micheldun Re: SumIf only if value is... 11-05-2012, 04:06 PM
  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Oklahoma
    MS-Off Ver
    Excel 2007
    Posts
    4

    SumIf only if value is above a certain number

    I have used SumIf to determine add numbers using the regular criteria, for example:
    =sumif($A1:$A6,$A1:$A6,$B1:$B6) to return the sums of values in B that match the row criteria in A many times with great success.

    Now I need to do something more complicated. I only want to sum the value in B if it is over a specific number, like 10. I have tried nesting an IF statement and it doesn't look like that is the way to go.

    Thanks in advance for your help,

    micheldun
    Last edited by micheldun; 11-05-2012 at 04:10 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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