Hi, thanks for reading this. I have a 2 page workbook with invoice data
entry on the first page and i am looking to pull off totals onto the 2nd
page based on month number in the date column. My date column (B) contains
formatted date dd/mm/yy and for example column F contains the invoice sub
total in currency. My invoice dates are not in date order.
I want to have a row of fields on Sheet2 which have monthly totals in summed
from the data in sheet1, for example sum all the invoice totals of the whole
sheet if those invoices have the date month of 04.

I think I want to use VLOOKUP, maybe with Right or MID to pick the month out
of the date cell. What i am not sure about is how to put the function into a
range and is it all wrapped in a SUMIF?

Any help much appreciated, thank you.
Chris