Hi

Post back with a rough layout of how your data is stored on the sheet.
You'll probably end up using SUMPRODUCT or SUMIF (or even a pivot table),
but it's difficult to advise without seeing what info you have and where.

--
Andy.


"joemc911" wrote in message
...
I am not sure this is best placed in general, but here goes. I want to use
a
seperate workbook to tally daily data inputs, which I have working just
fine.
I then want to take some of the tallied data to another sheet, which only
needs current month data. Since the seperate workbook is built with each
month I need some sort of query or if, maybe lookup, function to look at a
selected month on the sheet where I want the data to go to and see that it
wants say january data to get only january data from the workbook, but
when
it is changed to february or march, it automatically gets data from the
proper place. I am thinking I might be able to create an IF statement
that
looks at selected data areas and finds the right month, then gets the data
from that months cell. I just don't know how to make that happen.