FIND UNIQUE

  • Thread starter Thread starter tlee
  • Start date Start date
T

tlee

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.
 
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.
 
works like a charm.

thanks.
Dave Peterson said:
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.
Click to expand...
 
Back
Top