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

Recent content by cecilia100754@gmail.com

  1. C

    multiple criteria in one cell

    See attachment above. I have attached a sample excel document. Tab 3 (AHIC-TBI-UTICA) has a formula in each category. The first tab is the spreadsheet where all the initial information will be entered. there are drop down boxes indicating programs and categories of incidents. On Tab 3, I...
  2. C

    multiple criteria in one cell

    https://www.dropbox.com/s/ziatkgsjpmvycz2/Incident%20Log%20-%202013%20TEST2.xls
  3. C

    multiple criteria in one cell

    I have a dropbox file to post a sample workbook.
  4. C

    multiple criteria in one cell

    How do i upload sample? sorry, first time on this blog.
  5. C

    multiple criteria in one cell

    current formula that i have is a "countif". Can i enter multiple criteria in a cell with the "countif" formula?
  6. C

    multiple criteria in one cell

    other formula did not work either. i don't have numbers in column C or D. I know I want the formula to add but I'm using words instead of numbers. Is there a formula for that?
  7. C

    multiple criteria in one cell

    I guess I should have mentioned that the formula is appearing on another tab in the spreadsheet. I'll try the new formula.
  8. C

    multiple criteria in one cell

    error message appeared in cell #N/A. probably stupid on my part, but i need a number in the category column. it will be counting how many times AHIC-TBI-UTICA had a HOSPITALIZATION.
  9. C

    multiple criteria in one cell

    thanks, i'll try it and let you know.
  10. C

    multiple criteria in one cell

    Column C has program names, i.e. AHIC-TBI-UTICA. Column D has classifications, i.e. hospitalizations. How do I write the formula that will capture the program and the corresponding classification? I need to have totals of hospitalizations that occurred in AHIC-TBI-UTICA.
See more
Back
Top