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

multiple criteria in one cell

C

cecilia100754@gmail.com

New Member
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.
 
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.
 
Ok,


You should be trying the formula in column E.


Else, use this


=SUMPRODUCT(($C:$C="AHIC-TBI-UTICA")*($D:$D="hospitalizations"))
 
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?
 
No Problem.


Just click the "Forums" link at the top of this page, below the heading bar. Then you will see a list of questions posted. From the top, choose the third one that says "[sticky] [closed] Posting a sample workbook". Then just follow the instructions in this page.


regards,

Prazad
 
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 need to capture the program (in this case AHIC TBI UTICA)and I also need to capture each one of the categories for that program, i.e. if AHIC TBI UTICA had 3 hospitalizations and 1 sensitive situation, that information would be carried over from the first tab to tab 3. note that the other tabs are labeled with different program names; the template will be carried over to each tab to capture each program and its categories.
 
Hello Cecilia,


Please check this file and let me know, if this is what you are looking for.


http://www.2shared.com/document/qlRzEtj3/Incident_Log_-_2013_TEST2.html


Thanks,

Prazad
 
You must log in or register to reply here.
Back
Top