=SUMIF(A:A,"DEL",C:C)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"daviesnc" wrote in message
...
I have 3 columns of data in a spreadsheet, and I need to create a report

Example-
Airline DelayCode Time
ABC - DEL - 2.00
DEF - DEL - 1.33
ABC - REJ - 3.44
GHI - DEL - 3.50
ABC - XYZ - 1.05

What I need is a report of the number showing the number of time that
airline ABC was delayed. how many times DEL, or REJ (or whatever) appears,
and what the total time was, per code , and as a grand total. (Here, ABC
was
delayed 3 times in total. Twice for 'DEL' (time: 5:50), and once for XYZ
(time: 1:05); Grand TOTAL of delays = 6:55 (5:50 + 1:05)

I will then make charts from the data, I'd really appreciate some help
with
this as I don;t even know the terminology of the thing I'm trying to do !!