I am using the countif function to count only those items achieving a certain criteria. My problem is I have a certain range wherein there are two items (criteria) I want to include in my logic so that those two items will be included in the count. Let us take for example I want to count in a range that should meet "Water" and "Gas" altogether.
Thank you!
I had added details for better illustration purposes. Here's my table of data:
My criteria would be as follows:
I only want to include the following items meeting a series of criteria, arranged in order of priority:
- Priority 1: Column "Company": Items under Company "A"
- Priority 2: Column "Status": Items under "On-Going" and "Completed"
- Priority 3: Column "Type of Project": Items under "Program Development"
- Priority 4: Column "Application": Items under SAP and HRIS application
Based on my own analysis without using excel formulas, I would come up a total of 3 items: Item No. 1, Item No. 3, and Item No. 4, that met the criteria set. Now I want to do this using the excel logic.
Thanks again for the help.