LRBryan wrote:
Bernard, I did give this a try but am thinking this is not really doing what
I need it to do because I'm not trying to sum products.

To explain, I have a number of lines containing account codes (col C6:C58)
and budgeted amounts (col E6:E58).

In a single cell, I need to sum the budgeted amounts of all accounts that
have codes that fall between 5100 and 5999, OR if they are accounts 5007 or
5008.

Thanks!



Are you saying you tried it and you got the wrong answer, or that you think it
won't work because you believe the wrong function was suggested. SUMPRODUCT is
the correct function for your problem.