Sum product based on 2 values

[Peter1973]

I am trying to find a way to :

Look in A1:A100 for all cells that =FT/DR
Then in all those cells look in all the ones in B1:B100 that are between 00:00-08:00

Then in the cells that meets both criteria sum the ones with H in C1:C100

Any help appreciated

 

[Dave Patton]

Do you mean count the rows that meet your criteria?
With the criteria in cells E1:H1

=sumproduct(--(a1:a100=e1),--(b1:b100 > f1),--(b1:b100 < g1),--(c1:c100=h1))

To sum the cells in B that meet your criteria

=SUMPRODUCT(--(A1:A100=E1),--(B1:B100 > F1),--(B1:B100 < G1),--(C1:C100=H1),(B1:B100))

Format the result to your preference.

 

[Dave Patton]

I had trouble with the Internet.

Do you mean count the rows that meet your criteria?
With the criteria in cells E1:H1

=SUMPRODUCT(--(A1:A100=E1),--(B1:B100 > F1),--(B1:B100 < G1),--(C1:C100=H1))

or to Sum the times in Column B

=SUMPRODUCT(--(A1:A100=E1),--(B1:B100 > F1),--(B1:B100 < G1),--(C1:C100=H1),(B1:B100))

N.B. format the the result to your preference.
You may require a custom format such as [h]:mm

 

[Peter1973]

Soory may have not explained properly I mean sum the ones in C1:C100 which meet both criteria and have the letter H in them.