+ Reply to Thread
Results 1 to 2 of 2

Help finding total amount of certain criteria from worksheet and display in another cell

  1. #1
    Registered User
    Join Date
    07-19-2015
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2013
    Posts
    17

    Help finding total amount of certain criteria from worksheet and display in another cell

    Hello,

    I seem to have no problems with finding averages for my golf worksheet attached.

    But what I also need to find is:


    total number of holes played -1 par (birdies)
    total number of holes played -2 par (eagles)

    so on so on. I realise if someone helps me crack the formula to find birdies I can do it for eagles, pars, bogeys myself.

    par value is highlighted in cells b2:b52 in "input scores" sheet.

    any help would be gratefully received.example worksheet.xlsx

    Mark wilson

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Help finding total amount of certain criteria from worksheet and display in another ce

    Quote Originally Posted by m77wls View Post
    I realise if someone helps me crack the formula to find birdies I can do it for eagles, pars, bogeys myself.
    OK, for Birdies...

    =SUMPRODUCT(--(B4:S8+1=B2:S2))

    Result: 12
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding the total amount within a date range.
    By jcarey5225 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2015, 09:34 AM
  2. how to work out rate based on total time and total amount
    By lisaathers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2013, 06:44 AM
  3. Need to chart both amount and percentage from a cell as total
    By Taiter in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-25-2013, 09:50 AM
  4. Multiple criteria sum to calculate total amount per annum"
    By chunlee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2010, 08:30 AM
  5. Finding an amount in an adjacent cell
    By hbrenner in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-24-2009, 09:06 PM
  6. Finding the first amount in a cell
    By erickguz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2007, 11:04 AM
  7. [SOLVED] How do I calculate Amount of Sales Tax from Total Amount?
    By MikeS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 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