Formula Changed

[JimS]

I had this formula in a cell:

=SUMPRODUCT((E23:E2500)*(F23:F2500=9)*(G23:G2500=6.5))

It did work fine. The E column represents time in the 13:30 format,
so 27 minutes or 1:27, etc.

I had to change the formula for calculating time in the E column so it
would calculate hours that went past midnight. When I did that the
above formula now returns a #Value! error.

However, the formula does work where there are no blank rows in my
data!

This is the formula in my time calculation column:

=IF(D213="","",D213-C213+(D213<C213))

I'm lost on this one.

 

[Dave Peterson]

I'd try:

=SUMPRODUCT((E23:E2500),--(F23:F2500=9),--(G23:G2500=6.5))

When you multiply (using *), those text entries (including "") will cause
problems.

 

[Bob Phillips]

=SUMPRODUCT(--(F23:F2500=9),--(G23:G2500=6.5),E23:E2500)

 

[JimS]

You guys are amazing. Thanks again.