Value return meeting criteria in table

[KevinYells]

Hi all

I have a spreadsheet that has multiple values. Specifically I want to calculate a VOLUME in one row that meets the PRODUCT VALUE in another row. As example a product value of 1 (specific to a product) would have a case count in the spreadsheet. There are multipleproducts and I need a formula to return the cases for an individual. Instead of filtering each product and then copying the total cases.

Help appreciated

Many thanks

[shukla.ankur281190]

Post a sample spreadsheet with desired result.

http://www.excelforum.com/members/da...ch-a-file.html

[KevinYells]

Book1.xlsx

Column D is the value I want to calculate against the product range in column f (call product)

example column F call product 11 is 60040 returned from column d

Regards

[shukla.ankur281190]

Put I2 =IFERROR(INDEX($F$2:$F$311,MATCH(0,COUNTIFS($I$1:I1,$F$2:$F$311),0)),"") with Ctrl+Shift+Enter and drag down for unique Call product list.

Please Login or Register  to view this content.

Put J2 =SUMIF($F$2:$F$311,I2,$D$2:$D$311) and drag down for sum the result on criteria base.

Please Login or Register  to view this content.

Excel is attached.