Counting with 2 criteria
I figured out how to sum a column of $ values for a specified associate. If
it would help someone else, the formula with the name in Col A and the $
values in Col H:
=SUMPRODUCT(--(A1:A100="associate name"),--(H1:H100))
--
Amethyst
"Amethyst" wrote:
I need to be able to pull counts from a frequently updated list based on
associate's name and status of order.
--
Amethyst
|