I am trying to summarise worksheets in a workbook

Hi

I am after a formula that totals all reference matches on adjacent worksheets. So I have a summary sheet with the reference numbers but need to total all payments received by month. I can have more than one payment in each month so cannot use VLOOKUP

Spreadsheet attached

Thanks in advance

Andy

Currently struggling to upload sample spreadsheet but below is the summary sheet contents. I then have worksheets for Jan, Feb, Mar etc

Summary worksheet
Ref No Jan
111SCF total of payments in January against 111SCF reference
112SCF total of payments in January against 112SCF reference
113SCF
114SCF
115SCF
116SCF
117SCF
118SCF

Summary, Jan, Feb, Mar, Apr

Ok, well your spreadsheet isn't attached but if you are looking to sum payments by month look into using sumifs or sumproduct.
this is an example of a sumifs used with dates...
=SUMIFS($N$2:$N679,$E$2:$E679,">="&DATE(2014,7,1),$E$2:$E679,"<="&DATE(2014,7,31))
in this formula you would be summing what is in N2 through N679 based on the dates in E2 through E679 that are greater than or equal to July 1 2014 and less than or equal to July 31 2014.
You can adjust the ranges for yours using that logic.

this would accomplish it but you have to repoint it for each tab...
=SUMIF(Jan!$B$2:$B$19,Summary!A3,Jan!$C$2:$C$19) takes care of the Jan tab.
you would need to use an embedded indirect to have it advance tab to tab without repointing it.
I'll play with that but it is more complex.

OR as Pete showed below, easy.