SUMIF - VLOOKUP

  • Thread starter Thread starter mcp201
  • Start date Start date
M

mcp201

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
 
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)
 
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.
 
Did you try
=sumif(A:A,<=rundate,D:D)

mcp201 said:
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.
Click to expand...
 
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:

RE: SUMIF - VLOOKUP
14-Nov-08

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

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

:

EggHeadCafe - Software Developer Portal of Choice
XML Serializer Generator and Application Perfomance
http://www.eggheadcafe.com/tutorial...b9-dd68447ba187/xml-serializer-generator.aspx
 
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/tutorial...5b-710b108d13fd/inmemory-data-compressio.aspx
 
Back
Top