View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amethyst Amethyst is offline
external usenet poster
 
Posts: 16
Default 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