Results 1 to 14 of 14

Subtotal Count Of Help

Threaded View

swoosh1014 Subtotal Count Of Help 10-13-2014, 03:51 PM
sati Re: Formula Help 10-13-2014, 03:58 PM
alansidman Re: Formula Help 10-13-2014, 04:08 PM
ChemistB Re: Formula Help 10-13-2014, 04:09 PM
swoosh1014 Re: Formula Help 10-13-2014, 04:16 PM
Speshul Re: Count of Subtotal Help 10-13-2014, 04:20 PM
swoosh1014 Subtotal Count Of Help 10-13-2014, 04:32 PM
swoosh1014 Re: Count of Subtotal Help 10-13-2014, 04:29 PM
Jonmo1 Re: Subtotal Count Of Help 10-13-2014, 04:48 PM
swoosh1014 Re: Subtotal Count Of Help 10-13-2014, 05:11 PM
Jonmo1 Re: Subtotal Count Of Help 10-13-2014, 05:14 PM
Jonmo1 Re: Subtotal Count Of Help 10-13-2014, 05:23 PM
swoosh1014 Re: Subtotal Count Of Help 10-13-2014, 05:27 PM
Jonmo1 Re: Subtotal Count Of Help 10-13-2014, 05:29 PM
  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Houston,TX
    MS-Off Ver
    Excel 2010
    Posts
    19

    Subtotal Count Of Help

    Hello,

    I am trying to get a formula working but have been having difficulities producing the desired results. I am wanting a subtotal formula (so that I can filter) that will give me a # value when Column I has a value of "Win" and Column O has an amount greater than 0. I would also like to have this formula ignore a result when Column O is blank. My data range starts in Row 12 and I plan on making it a dynamic range due to future entries. Any help would be greatly appreciated!

    To help better illustrate what I am looking for:

    Column I Column O

    Win 5
    Loss -12
    Win 7
    Win 8
    Win
    Loss -1

    In this example, I would want my formula to exclude the Win with a blank value in column O, resulting in a desired total of "3" .
    Last edited by swoosh1014; 10-13-2014 at 04:43 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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