| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP & SUMIF | Excel Worksheet Functions | |||
| sumif or vlookup help | Excel Worksheet Functions | |||
| Sumif/vlookup/left | Excel Discussion (Misc queries) | |||
| vlookup, sumif, if, countif, help | Excel Worksheet Functions | |||
| SUMIF using VLOOKUP as criteria | Excel Worksheet Functions | |||
Linear Mode
