Posted to microsoft.public.excel.worksheet.functions

Amethyst

external usenet poster

Posts: 16

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting with 2 different criteria	Roman	Excel Discussion (Misc queries)	1	October 9th 08 09:36 PM
Counting criteria	andrew	Excel Discussion (Misc queries)	16	June 19th 08 02:43 AM
Counting more than one criteria	Justin Chips	Excel Discussion (Misc queries)	4	February 25th 08 08:53 PM
Counting Cells with multiple criteria.One criteria supporting wild	Azhar Saleem	Excel Worksheet Functions	1	January 12th 05 10:54 AM
Counting Cells with multiple criteria.One criteria supporting wild	Azhar Arain	Excel Worksheet Functions	1	January 12th 05 08:33 AM

All times are GMT +1. The time now is 08:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us