LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default SUMIF PROBLEM

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF problem richierich1961 Excel Worksheet Functions 5 September 28th 07 02:09 PM
sumif problem vincent135 Excel Discussion (Misc queries) 3 June 14th 06 03:08 PM
SUMIF problem wahur Excel Worksheet Functions 2 May 9th 06 02:06 PM
SumIf Problem Brian Matlack Excel Discussion (Misc queries) 7 April 18th 06 12:26 AM
SUMIF problem Easydoesit Excel Worksheet Functions 5 June 16th 05 10:17 PM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"