Add all data from no of sheet for same category

[Nitikesh]

Hello All,

Please help me regarding my problem.
I want to add all data for same category from no of sheet. Sample workbook attached please find that.

Thanks in advance

Nitikesh

[Sadath31]

Hi

array formula {=SUM(SUMIF(INDIRECT("'"&$M$2:$M$4&"'!A2:A100"),$B3,INDIRECT("'"&$M$2:$M$4&"'!c2:c100")))}

where M$2:$M$4 contain your sheet names (SAMPLE 1, SAMPLE 2, SAMPLE 3)

[Nitikesh]

Hi

array formula {=SUM(SUMIF(INDIRECT("'"&$M$2:$M$4&"'!A2:A100"),$B3,INDIRECT("'"&$M$2:$M$4&"'!c2:c100")))}

where M$2:$M$4 contain your sheet names (SAMPLE 1, SAMPLE 2, SAMPLE 3)

Thanks for your help. But am I apply this formula its return #value error. I think I am mistaking in syntax error during selecting sheet.
Can you apply this formula in attached sheet.

Thanks

[Sadath31]

Hi
pls find the attached..

[Sadath31]

Missed to attach..

[Nitikesh]

Missed to attach..

Thanks again

[Nitikesh]

Missed to attach..

One more query

Is it compulsory to write the sheet reference name in result sheet or can we do with that also.