• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    average countif - better example

    I was using column headers in the example below (category & rating). I want it to average all the numbers in the rating column if the category is accessibility. =AVERAGE(COUNTIFcategory,"Accessibility")+COUNTIFrating,">0")
  2. G

    average fomula using also count if

    Thanks Fred! I was using column headers in the example below (category & rating). I want it to average all the numbers in the rating column if the category is accessibility. Sorry for the lame example. =AVERAGE(COUNTIFcategory,"Accessibility")+COUNTIFrating,">0")
  3. G

    average fomula using also count if

    I have columns in a spreadsheet - one is animal type the next is animal age. I need to find the average age of dogs. I was thinking =countif(animaltype,("Dog"))) but also need to find the average of that total.
  4. G

    sumif then subtract

    Fantastic - thanks!
  5. G

    sumif then subtract

    176 is the number I want the total from the sumif's to subtract from.
  6. G

    sumif then subtract

    Is it possible to combine several sumif's and then subtract it from a base number? Here is my best attempt...
Back
Top