Assume your summary table starts with names in X2 on the same sheet,
and that you have 250 rows of data starting on row 2. It might look
better if you used column Y for under 24 hours and column Z for
greater than 24 hours, so put this formula in Y2:

=SUMPRODUCT(($B$2:$B$250=$X2)*($F$2:$F$250<1))

and this in Z2:

=SUMPRODUCT(($B$2:$B$250=$X2)*($F$2:$F$250=1))

Note the similarity of the formulae - you can copy from Y2 into Z2 and
just amend the end part. Adjust the ranges from 250 if you have more
data than this.

Not sure why you told us that column H is status, as we haven't used
that.

Hope this helps.

Pete

On Feb 11, 5:16*pm, Jeremy <jeremiah.a.reynolds @ gmail.com wrote:
I have a table of information that I need to simplify into a summary table..

Column B = Name
Column F= Time
Column H = Status

I need to count all of the the items that have a time of greater than 24
hours and all of the times that have a time of less than 24 hours. *To
further complicate things, I need to count by individual names.

My Hope is to have the final table look something like this:

Billie (Under 24 Hours) * * [Number]
Billie (Over 24 Hours) * [Number]

Jeremy (Under 24 Hours) * * [Number]
Jeremy (Over 24 hours) * * [Number]
There will also be names that are not on the list. *I need those to return
Zero.

Please help.