Sum If Function
 

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...o&userid=23686
View this thread: http://www.excelforum.com/showthread...hreadid=388383

"bhigdon" wrote:


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...o&userid=23686
View this thread: http://www.excelforum.com/showthread...hreadid=388383


fx:
use
CONCATENATE

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



bhigdon Wrote:
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.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388383

If I understand what you're looking for:

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

In article ,
bhigdon wrote:

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.