Index With Sum Formula

[sgmpatnaik]

Hello Sir,


If we use one ERA Formula with Criteria Formula then how can we add the Sum formula


example


=IFERROR(INDEX(DISP_BRAND,SMALL((DISP_DEAL_NAME="XYZ")*(DISP_BRAND="XYZ")*ROW(DISP_DEAL_NAME),COUNTA(DISP_DEAL_NAME)-COUNTIF(DISP_DEAL_NAME,"XYZ")+ROW(A1))-ROW(DISP_DEAL_NAME)+1),0)


THEN IS IT POSSIBLE TO ADD THE SUM FUNCTION, IF POSSIBLE KINDLY SUGGEST


HENCE I OBLIGE


WITH REGARDS


PATNAIK

 

[Luke M]

Very hard to understand exactly what your formula is doing since we don't know what all those named ranges are. My first guess is that you could probably do this with a SUMIFS or SUMPRODUCT formula, but I'd need a clearer definition of what the criterias are.

 

[SirJB7]

Hi, sgmpatnaik!

Adding to what Luke M said, a sample file with detailed examples and manually created output as desired will be helpful too.

Regards!

 

[sgmpatnaik]

Thank Q Mr Luke M and Sir JB 7 Sir


for your kind information i am attach my file please check in the reports Button of Godown Wise Reports and i want the Details of Sum in BP & GP Button


https://dl.dropbox.com/u/75654703/KPT%20Accounts.xls


With Regards


Patnaik

 

[sgmpatnaik]

Thank Q Mr Luke M and Sir JB 7 Sir


for your kind information i am attach my file please check in the reports Button of Godown Wise Reports and i want the Details of Sum in BP & GP Button


https://dl.dropbox.com/u/75654703/KPT%20Accounts.xls


With Regards


Patnaik