Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My formula is:- =SUMIF('INPUT PAGE - FLYING TIMES'!$D$4:$D$23,D3,'INPUT
PAGE - FLYING TIMES'!$H$4:$J$23) D4 to D23 is the part of my data which I'm looking for the answer in D3 (aeroplane type). H4:J23 is where I looking for a numerical figures (flying time in minutes) This is working well for the first column, (H) but is not taking note of the 2nd and 3rd column. 1/ Am I using the correct formula to pick data from 3 columns? 2/ If correct what should I do to the formula to make it work across all 3? 3/ If not, which one should I go for? Malcolm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF problem | Excel Worksheet Functions | |||
sumif problem | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions | |||
SumIf Problem | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions |