Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding multiple data fields from time based data.
Ok so heres my problem.
I have a workbook which has the following columns: Date, A/C Type, Rego, PIC, Co-Pilot, and then 13 columns of different types of flying. What I need, and have been trying to figure out, is a formula which will compare todays date to that of 30 and 90 days ago and then add all the data within the 13 columns to give me the total number of hours flown in the previous 30 and 90 days, on any aircraft type, configuration, etc. I have tried SUMIF, COUNTIF, and a few other basic formulas, but for some reason any time I try and add in TODAY, NOW, etc it makes the formula volitile and either returns an error or 0. If anyone can give me any ideas on which formulas to try, it would be a great help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding multiple data fields from time based data.
Have a look at SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "JMK" wrote in message ... Ok so heres my problem. I have a workbook which has the following columns: Date, A/C Type, Rego, PIC, Co-Pilot, and then 13 columns of different types of flying. What I need, and have been trying to figure out, is a formula which will compare todays date to that of 30 and 90 days ago and then add all the data within the 13 columns to give me the total number of hours flown in the previous 30 and 90 days, on any aircraft type, configuration, etc. I have tried SUMIF, COUNTIF, and a few other basic formulas, but for some reason any time I try and add in TODAY, NOW, etc it makes the formula volitile and either returns an error or 0. If anyone can give me any ideas on which formulas to try, it would be a great help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple fields to a Pivot table at one time | Excel Discussion (Misc queries) | |||
Can I pivot multiple data fields and display them in a column? | Excel Discussion (Misc queries) | |||
Adding Date/Time fields | New Users to Excel | |||
Adding specific objects based on data... | Excel Discussion (Misc queries) | |||
Pivot Tables multiple data fields | Excel Worksheet Functions |