COUNT FUNCTION?

Z

Zakynthos

If Col A contains a text variable and column B contains a numerical variable
associated with the text variable, what is the simplest formula I can put
into a single cell that will count the number of occurrences of the numerical
variables in Col B associated with the text variable in A?
 
O

Otto Moehrbach

A few examples of what you want counted and what you don't want counted
would be helpful. HTH Otto
 
Z

Zakynthos

Otto,

Say column A contains 3 occurrences of the name 'Otto' and Column B contains
sums of money associated with the name Otto, perhaps B2 has $2000, B4 $10000
and B7 $200000.

What formula could I input say to C7 that would return the answer '3' - i.e.
the number of values in Column B associated with the name 'Otto' in Column A?

Many thanks.
 
M

Max

Something like this, in C7:
=SUMPRODUCT((A2:A7="Otto")*ISNUMBER(B2:B7))
Adapt the ranges to suit
 
P

Peo Sjoblom

=SUMPRODUCT(--(A2:A100="Otto"),--(ISNUMBER(B2:B100)))


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating the User Profile location into a document template path 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Is there a function to count how many times a cells value is used? 0
Count columns that meet criterias 3
VBA word change keys 0
Loop Through Text and Test for Scenarios Q 31
Using sumproduct function to count cell values on a remote workbook 3
Sum of Variable Cells in a fixed Row 3

Top