• 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. E

    MEDIAN IF

    Hui, can i buy you a beer or 250 of them?? Excel ninja is correct!!!!!!!!
  2. E

    MEDIAN IF

    I seem to be having a terrible 'Friday' moment. =MEDIAN(IF('RTW Same Employer'!N114:N147,"<=24",'RTW Same Employer'!N114:N147)) Using it as a stanard formula and it comes up with #VALUE Using it as an array formula and it comes up with #NUM Any assistance would be grately appreciated...
  3. E

    COUNTIF With multiple criteria

    Hui, i may possibly be your new biggest fan. Thank you!!!!!!!
  4. E

    COUNTIF With multiple criteria

    I am trying to find the number of claims within a worksheet that meet three critera's. I have tried to use =COUNT(IF('RTW Same Employer'!M6:M64,"<=24",IF('RTW Same Employer'!I6:I64,("<=31/03/2011"),IF('RTW Same Employer'!J36:J64,"5")))) =SUMPRODUCT(--('RTW Same...
Back
Top