I have 12 cells, one for each month of the year. I need each of the
cells to reference the dates on other worksheets in order to summarize
my data. For instance, my profit summary should show the profit for
January in cell J8 of one worksheet, but only if the PO date on
another worksheet is in January. February should show the profit only
if the PO is in Feb, and so on. Probably a very easy task, but I
can't seem to find it in excel help. Can anybody help on this one?
Thank you in advance.