Counting with 2 criteria
I need to be able to pull counts from a frequently updated list based on
associate's name and status of order. -- Amethyst |
Counting with 2 criteria
=SUMPRODUCT(--(A1:A100="associate name"),--(B1:B100="status"))
should do it for you, adjust the columns/rows to match your sheet. You could have a couple of cells to enter associate name/status into to make things easier; as associate name in C1 and status in D1: =SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1)) "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 |
Counting with 2 criteria
Thanks so much! That works beautifully. Now I need to be able to add the
dollars in a column that belongs to that associate. -- Amethyst "JLatham" wrote: =SUMPRODUCT(--(A1:A100="associate name"),--(B1:B100="status")) should do it for you, adjust the columns/rows to match your sheet. You could have a couple of cells to enter associate name/status into to make things easier; as associate name in C1 and status in D1: =SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1)) "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 |
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 |
All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com