Soldato
- Joined
- 25 Mar 2004
- Posts
- 16,007
- Location
- Fareham
Hi guys, for my job I fill in an excel sheet with details of all the cases I deal with, basically it goes a bit like this:
column 1 | column 2 | column 3 | column 4
"case number" "case type" "escalation/resolved" "case category"
case number - simply a 5 digit number, this is always filled in if the row is for a case
case type - internal case or external case
escalation/resolved - states whether we escalate the case to another department or if we resolve the case
case category - the kind of case we are dealing with, we have a long list to choose from
Basically I want to be able to tally some results automatically, I want to create another sheet on the workbook, and in this sheet add some values that get automatically calculated
For example I would like to be able to count the number of external cases that get escalated to a specific department, or resolved etc
I can't think of a way to automate this off the top of my head, as you need to count if certain values are true across the row. so I want a formula that does something like this:
If Column 1 is not empty, if Column 2 is external case, and column 3 is resolved, and column 4 is category x then add the number of rows where this is true to get a total
Is this possible? any questions let me know
column 1 | column 2 | column 3 | column 4
"case number" "case type" "escalation/resolved" "case category"
case number - simply a 5 digit number, this is always filled in if the row is for a case
case type - internal case or external case
escalation/resolved - states whether we escalate the case to another department or if we resolve the case
case category - the kind of case we are dealing with, we have a long list to choose from
Basically I want to be able to tally some results automatically, I want to create another sheet on the workbook, and in this sheet add some values that get automatically calculated
For example I would like to be able to count the number of external cases that get escalated to a specific department, or resolved etc
I can't think of a way to automate this off the top of my head, as you need to count if certain values are true across the row. so I want a formula that does something like this:
If Column 1 is not empty, if Column 2 is external case, and column 3 is resolved, and column 4 is category x then add the number of rows where this is true to get a total
Is this possible? any questions let me know