SUMIF - VLOOKUP
 

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

SUMIF - VLOOKUP
 

use SUMPRODUCT. I assume the dates in column A and the 11/14/08 are dates in
the workbook


=countif(--(book1!a1:a100=DATEVALUE("8/1/07")),book1!b1:b100)

"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

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

SUMIF - VLOOKUP
 

Your formula is not working. I also forgot to mention that there are 2 rows
with data in between the date column and sales column.



"Sean Timmons" wrote:

=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

SUMIF - VLOOKUP
 

Did you try
=sumif(A:A,<=rundate,D:D)

"mcp201" wrote:

Your formula is not working. I also forgot to mention that there are 2 rows
with data in between the date column and sales column.



"Sean Timmons" wrote:

=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

Vlookup and sum based on sates
 

Hi, I am attempting to perform a vlookup and sum aircraft US fiscal year flying hour data using the monthly inputs (sheet 1) and based on the report requested time frames (sheet2)... any help would be greatly appreciated...


My data is this....

Dates sheet1!d24:024, corresponding flying hours in sheet1!D25:025

D24 Oct 08..... D25 300 hrs
E24 Nov 08.......E25 250 hrs
..
..
..
F24 Sep 09...... F25 100 hrs

report "start date" in sheet2!A3 is Nov 08
Report "End date" in sheet2!A4 is Jan 09

need sum of flying hours in cell A5 based on report start date (cell p4)and end date (cell p5)

(recognize the cell references don;t really matter just looking for the right formula).

Thanks,

Dave Choquette






Joe wrote:

SUMIF - VLOOKUP
14-Nov-08

use SUMPRODUCT. I assume the dates in column A and the 11/14/08 are dates in
the workbook


=countif(--(book1!a1:a100=DATEVALUE("8/1/07")),book1!b1:b100)

"mcp201" wrote:

EggHeadCafe - Software Developer Portal of Choice
XML Serializer Generator and Application Perfomance
http://www.eggheadcafe.com/tutorials...generator.aspx

Correction to the reference in my first note
 

Correcting the ref.. should be

need sum of flying hours in cell sheet2!A5 based on report start date (sheet2!A3)and end date (sheet2!A4).



Dave Choquette wrote:

Vlookup and sum based on sates
08-Oct-09

Hi, I am attempting to perform a vlookup and sum aircraft US fiscal year flying hour data using the monthly inputs (sheet 1) and based on the report requested time frames (sheet2)... any help would be greatly appreciated...


My data is this....

Dates sheet1!d24:024, corresponding flying hours in sheet1!D25:025

D24 Oct 08..... D25 300 hrs
E24 Nov 08.......E25 250 hrs
..
..
..
F24 Sep 09...... F25 100 hrs

report "start date" in sheet2!A3 is Nov 08
Report "End date" in sheet2!A4 is Jan 09

need sum of flying hours in cell A5 based on report start date (cell p4)and end date (cell p5)

(recognize the cell references don;t really matter just looking for the right formula).

Thanks,

Dave Choquette

EggHeadCafe - Software Developer Portal of Choice
In-Memory Data Compression in .NET Part III
http://www.eggheadcafe.com/tutorials...ompressio.aspx