SUMIF - VLOOKUP
=sumif(A:A,<=rundate,B:B)
"mcp201" wrote:
I have a 2007 file which has sales for each day from August to the end of the
year. My 2008 file which is currently used looks into the 2007 file for data.
I am trying to sum the sales from August to the current run date which is
already used in a formula. What would be the easiest way to do this? Thanks
in advance.
Ex:
Sales Run Date
Aug 10 55555 11/14/08
Aug 11 555556
Nov 14 444444
......... 88888
Dec 14 77777
|