Regarding SUMIF

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

barry houdini

Hello Raj,

You can use SUMPRODUCT

Assuming your base data is in columns A, B and C then with your
priorities, P1, P2 etc. listed in E2 down use this formula in F2
copied down

=SUMPRODUCT((A$2:A$100="Closed")+(A$2:A$100="Resolved"),--(B$2:B
$100=E2),C$2:C$100)

adjust ranges as necessary...
 
B

Bernard Liengme

Assuming row 1 has the labels "Status", "Priority", "aging", and the status
data in in A2:A4000
And that P1 and P2 for results are in D1 and D2
=SUMPRODUCT((($A2:$A$4000="Closed")+($A$2:$A$4000="Resolved"))*($B$2:$B$4000=D1)*($C$2:$C$4000))
Happy New Year
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top