SumIf function/VBA help

[Xineq]

Hey Mr.Excel

I currently working on a project there i need find the total effort of assignments. The effort is in a Excel ark.

This is an example on the ark.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Item[/TD]
[TD]Release[/TD]
[TD]PlanID[/TD]
[TD]OP[/TD]
[TD]Prio[/TD]
[TD]Effort[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]Product[/TD]
[TD]20-1[/TD]
[TD]10[/TD]
[TD]Mads[/TD]
[TD]1[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]Product[/TD]
[TD]20-1[/TD]
[TD]10[/TD]
[TD]Mads[/TD]
[TD]1[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]Feature[/TD]
[TD]20-2[/TD]
[TD]12[/TD]
[TD]Christian[/TD]
[TD]2[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

I want to calculate the total Effort of the product item. I'm trying to make a function that find all the planIDs that are the same, and is "Products", so if column B = Product and column D = PlanID on Sheet(Effort) A1 then Sum G.

Is this possible to make??

Best Xineq

 

[FormR]

I'm trying to make a function that find all the planIDs that are the same, and is "Products", so if column B = Product and column D = PlanID on Sheet(Effort) A1 then Sum G.

HI, something like this maybe:

=SUMIFS(G:G,D:D,Effort!A1,B:B,"Product")

 

[Xineq]

You are the man thanks a lot worked perfect

 

[FormR]

thanks a lot worked perfect

Great, good to hear