Need to sum based on two conditions

[minal]

Hello,
Please check my requirement and reply if you can. Thanks a ton!

Case I
Type Group Description Item Type Price
Core N Product1a Base 5,767.20
Core N Product1b Incre 5.77
Extended N Product2a Setup 0.00
Extended N Product2b Base 4,374.00
Extended N Product2c Incre 4.37
Extended N Product3a Base 200.00
Extended N Product3b Incre 2.00


Case 2
Type Group Description Item Type Price
Core Y Product1a Base 10,141.20
Core Y Product1b Incre 10.14
Extended Y Product2a Setup 0.00
Extended Y Product2b Base 0.00
Extended Y Product2c Incre 0.00
Extended N Product3a Base 200.00
Extended N Product3b Incre 2.00


I am looking for this:
If
Type = Core
Group = Y and
SUM all same item types' prices into the price column of the corresponding core row. (i.e. sum all base prices, sum all incre prices etc)
Case2 table shows my expected result.

Can someone please help?

-M

[minal]

Can someone help please?

[singerj6]

Your model is slightly confusing because the first expected result (cell E14) appears to be the sum of both a core and an extended value. Can you clarify further what you are looking for?

[minal]

Yeah..just realized it is confusing.

I want to sum all the prices, doesnt matter core or not, but the sum should be entered only against core. and the others that we used to sum up (other than core because that will have sum price) should be 0.

Does this make sense?
Thank you,
-M

[minal]

"Bump no response"

[icestationzbra]

question on post #4:

if that is the case, why isn't the value in cell E14 of your spreadsheet 10341.2? as i understand per your comment above, you want to add all "Base" prices up and show that value against "Core", similarly for "Incre". there is something more to the logic than that, i have a hunch...

[minal]

Hello,
Thanks for reply.
Because i want to sum all Base who have group = Y and all Incre who have group = Y and put that SUM in corresponding CORE row i.e. Sum should be only in Core- Base and Core- Incre. and All other rows that were added to this sum should be 0. and the ones that are not used in SUM should be kept as it is.

Price 200 for last base is not added because Group = N for this row.
Thanks.

[minal]

Any clue?
Thanks.

[icestationzbra]

see if this helps.

[FDibbins]

just looking at your data...

you say you want to add if Group = Y. but inthe file you supplied, none of the values in the top table meet that criteria, they are all Group = N?

[FDibbins]

@ icestationzbra they say you lean something new every day, well i just did.....

MATCH(A14&B14&C14&D14,$A$3:$A$9&$B$3:$B$9&$C$3:$C$9&$D$3:$D$9,0)

I didnt know you could use concatenation in a match() that way. many times i have had to use helper columns to produce that same result, thanks for sharing that

[icestationzbra]

@FDibbins: it is a trick that i have learnt on this forum from experts like yourself :-)...

[FDibbins]

nope, just learning as i go, like most of us here

[minal]

Thank you very much for superb answer icestationzbra! Works perfectly, I will implement this solution and will ask back to you if I face any more issues
Really words are not enough...but thank you for your time and sharing knowledge.

_Minal