FIND UNIQUE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tlee - 13 Oct 2004 00:19 GMT

I have a set of data with the following layout.

Assigned Territory Telesales Rep Sales Code
KANSAS CITY - FR UNASSIGNED
KANSAS CITY - FR UNASSIGNED A
KANSAS CITY - FR UNASSIGNED A

I want to be able to search through the assigned territory column and for
every occurrence of kansas city - fr, count the number of "a" that appear in
the sales code column.

tx in advance.

Reply to this Message

Dave Peterson - 13 Oct 2004 00:27 GMT

If you just want that one subtotal:

=sumproduct(--(a1:a999="kansas city - fr"),--(c1:c999="A"))

(Sumproduct likes to work with numbers. The double minuses convert true/falses
to 1/0's.)

If you want a subtotal for each option, you may want to look at a pivottable.

> I have a set of data with the following layout.
>
[quoted text clipped - 8 lines]
>
> tx in advance.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

tlee - 13 Oct 2004 00:45 GMT

works like a charm.

thanks.

> If you just want that one subtotal:
>
[quoted text clipped - 21 lines]
>>
>> tx in advance.

Reply to this Message