C
Civette
The formulas were not working consistently because some of the cells that
appeared to contain blanks actually had spaces in them and therefore were not
seen as blank by excel. Once I cleared all empty cells of potential spaces,
etc. the =SUMPRODUCT((E4:E869="1247.24")*(AC4:AC869<>"")) worked like a
champ.
Thanks for your help. It's thrilling when you finally figure out what was
causing the problem.
appeared to contain blanks actually had spaces in them and therefore were not
seen as blank by excel. Once I cleared all empty cells of potential spaces,
etc. the =SUMPRODUCT((E4:E869="1247.24")*(AC4:AC869<>"")) worked like a
champ.
Thanks for your help. It's thrilling when you finally figure out what was
causing the problem.