Which formula to use?

[Christine Jackson]

Hi Can anyone help me please.

I have 14 workbooks contained within a spreadsheet. Each workbook has info on different users/suppliers etc but has the same set up (i.e. each column contains the same set up).

I would like to have a summary workbook which searches all the workbooks and summarises the info for me.

eg

Column A Column B Column C
Row A 253 35000 35003
Row B 253 36000 35550
Row C 254 35000 35002

I would like it to look in Column A in each workbook and if = 253 add up all figures in Column B, and again look up A and if = 253 add up all in Column C.

Can anyone help?

Thanks

Chris

[shg]

Welcome to the forum, Christine.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.