G
Guest
Here is the formula I tried.
=SUMPRODUCT(--(E3:E27=TODAY()),--(E3:E27=TODAY()-1),(H3:H27))
Column E has dates. Column H has the numbers to total. I need the total of
the numbers in Column H if the date is either today or yesterday. This
formula always returns a 0.
=SUMPRODUCT(--(E3:E27=TODAY()),--(E3:E27=TODAY()-1),(H3:H27))
Column E has dates. Column H has the numbers to total. I need the total of
the numbers in Column H if the date is either today or yesterday. This
formula always returns a 0.