R
Raj
Hi
I have a issue using SUMIF statement my Data is distributed as below
Status Priority Ageing
Closed P1 2
resolved P1 1
Closed P2 3
Closed P2 4
The Data is distributed like this in more than 3000 cells. Now i want a data
like this
priority Total ageing
P1 3
P2 7
If the status is closed and resolved only we have count that for Total
Ageing if the status is other than both above we should not consider. Can
anyone help me to resolve this isuue.
I have a issue using SUMIF statement my Data is distributed as below
Status Priority Ageing
Closed P1 2
resolved P1 1
Closed P2 3
Closed P2 4
The Data is distributed like this in more than 3000 cells. Now i want a data
like this
priority Total ageing
P1 3
P2 7
If the status is closed and resolved only we have count that for Total
Ageing if the status is other than both above we should not consider. Can
anyone help me to resolve this isuue.