Formula Changed

  • Thread starter Thread starter JimS
  • Start date Start date
J

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.
 
I'd try:

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

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