Sum If Function

[bhigdon]

In one column I have different qualifiers. In another column I have
data. I want to create a formula that will sum all of the date in the
second column that is in the same row as the qualifier in the first
column. For example, if the entry in the first column=A, then I want
it to include the number in the second column in the Sum.

 

[ufo_pilot]

In one column I have different qualifiers. In another column I have
data. I want to create a formula that will sum all of the date in the
second column that is in the same row as the qualifier in the first
column. For example, if the entry in the first column=A, then I want
it to include the number in the second column in the Sum.


--
bhigdon
------------------------------------------------------------------------
bhigdon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23686
View this thread: http://www.excelforum.com/showthread.php?threadid=388383

fx:
use
CONCATENATE

 

[Morrigan]

Read about SUMIF() function. That's exactly what you want.

 

[JE McGimpsey]

If I understand what you're looking for:

=SUMIF(A:A,"A",B:B)