software

I have 2 columns. Col. A is number values. Col. B is text Name data.
What is the formula to count the number in Col. A IF the Col. B is
equal to a specific text name data. life quot;Stefaniequot;

AB
1Danny
1Stefanie
1Danny
1Danny
1Danny--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: www.excelforum.com/member.php...oamp;userid=31032
View this thread: www.excelforum.com/showthread...hreadid=523251If you want to count you can use countif

=COUNTIF(B1:B5,quot;Stefaniequot;)

if you want to sum the numbers that have Stefanie in another column

=SUMIF(B1:B5,quot;Stefaniequot;,A1:A5)
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;dannyboy213quot; gt;
wrote in message
...
gt;
gt; I have 2 columns. Col. A is number values. Col. B is text Name data.
gt; What is the formula to count the number in Col. A IF the Col. B is
gt; equal to a specific text name data. life quot;Stefaniequot;
gt;
gt; A B
gt; 1 Danny
gt; 1 Stefanie
gt; 1 Danny
gt; 1 Danny
gt; 1 Danny
gt;
gt;
gt; --
gt; dannyboy213
gt; ------------------------------------------------------------------------
gt; dannyboy213's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31032
gt; View this thread: www.excelforum.com/showthread...hreadid=523251
gt;=countif(b2:b99,quot;stefaniequot;)
(to just count the Stefanie's)
or
=sumif(b2:b99,quot;stefaniequot;,a1:a99)
to actually sum the values in column A.

Debra Dalgleish has lots of notes for counting and summing at:
contextures.com/xlFunctions04.html
contextures.com/xlFunctions01.html

dannyboy213 wrote:
gt;
gt; I have 2 columns. Col. A is number values. Col. B is text Name data.
gt; What is the formula to count the number in Col. A IF the Col. B is
gt; equal to a specific text name data. life quot;Stefaniequot;
gt;
gt; A B
gt; 1 Danny
gt; 1 Stefanie
gt; 1 Danny
gt; 1 Danny
gt; 1 Danny
gt;
gt; --
gt; dannyboy213
gt; ------------------------------------------------------------------------
gt; dannyboy213's Profile: www.excelforum.com/member.php...oamp;userid=31032
gt; View this thread: www.excelforum.com/showthread...hreadid=523251

--

Dave Peterson


Keep in mind that we we are counting the number values. The numbers can
vary.--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: www.excelforum.com/member.php...oamp;userid=31032
View this thread: www.excelforum.com/showthread...hreadid=523251What does that mean? Do you mean that there are blanks in the number column
and they should not be counted?
If so use

=SUMPRODUCT(--(A1:A10lt;gt;quot;quot;),--(B1:B10=quot;Stefaniequot;))

Or do you mean unique numbers in the first column with a name criteria, also
wouldn't it be reasonable that when you exemplify your problem that you
actually use something that is closer to the data you are working with than
to use
2 names and one number? Regardless

=SUM(--(FREQUENCY(IF(B1:B10=quot;Stefaniequot;,MATCH(A1:A10,A1:A1 0,0)),ROW(INDIRECT(quot;1:quot;amp;ROWS(A1:A10))))gt;0))

array entered will count the unique numbers in the A where B is quot;Stefaniequot;

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;dannyboy213quot; gt;
wrote in message
...
gt;
gt; Keep in mind that we we are counting the number values. The numbers can
gt; vary.
gt;
gt;
gt; --
gt; dannyboy213
gt; ------------------------------------------------------------------------
gt; dannyboy213's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31032
gt; View this thread: www.excelforum.com/showthread...hreadid=523251
gt;