Total number of entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know I have done this before, but a mind is a terrible thing

I have 3 columns of data

Column A contains pay scale (2 digit number
Column B contains office code (0 to 4 alpha characters
Column C contains city and state (many alpha characters

What I am attempting to do is take the data in each of these columns and get a figure as to how many times A=15, B=HUTS and C=Detroit MI. If on the worksheet this combination appears 3 times, then "3" is the number I want

Help....Tom
 
You can use Sumproduct Tom

=SUMPRODUCT((A1:A10=15)*(B1:B10="HUTS")*(C1:C10="Detroit MI"))


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Tom Kelly said:
I know I have done this before, but a mind is a terrible thing!

I have 3 columns of data.

Column A contains pay scale (2 digit number)
Column B contains office code (0 to 4 alpha characters)
Column C contains city and state (many alpha characters)

What I am attempting to do is take the data in each of these columns and get a figure as to how many times A=15, B=HUTS and
Click to expand...
C=Detroit MI. If on the worksheet this combination appears 3 times, then "3" is the number I want.
 
Hi Tom
try
=SUMPRODUCT((A1:A1000=15)*(B1:B1000="HUTS")*(C1:C1000="Detroit MI"))

Frank
 
Tom
You are probably thinkong of SUMPRODUC

=SUMPRODUCT((A1:A1000=15)*(B1:B1000="HUTS")*(C1:C1000="Detroit MI")

Good Luck
Mark Graesse
(e-mail address removed)

----- Tom Kelly wrote: ----

I know I have done this before, but a mind is a terrible thing

I have 3 columns of data

Column A contains pay scale (2 digit number
Column B contains office code (0 to 4 alpha characters
Column C contains city and state (many alpha characters

What I am attempting to do is take the data in each of these columns and get a figure as to how many times A=15, B=HUTS and C=Detroit MI. If on the worksheet this combination appears 3 times, then "3" is the number I want

Help....Tom
 
Back
Top