Sum question

[Bardo]

I know this is simple, but I can't find an example of the formula to apply.

I want to total dollar amounts based on "M" found in another column.

Trying sumproduct, but I can't get the structure correct. How would I write
this?

Dollar amounts found in column D and the "M" found in column G.

 

[Jason Morin]

In your case, SUMIF will do just fine:

=SUMIF(G:G,"M",D)

But if the formula needs to be case sensitive, then you
will need to use SUMPRODUCT.

HTH
Jason
Atlanta, GA

 

[Bardo]

Sumif would work if all the characters were M, but there are other
characters as well.

 

[Frank Kabel]

Hi
if you mean 'M' is somethere in a string try
=SUMIF(G:G,"*M*",D)

 

[Bardo]

No, there are other charcters in the column
example of column g

M
Z
Z

Z

So .. it would only add the numbers found in column D that had the letter
"M" found in column G

 

[Frank Kabel]

Hi
so you want to count all occurences of Text in column G?
Try
=SUMPRODUCT(--ISTEXT(G1:G1000))

or do you want to count only occurences of single characters?

 

[Bardo]

I want to count all the dollars found in the corresponding cells found in
column d ... where column G contains the character M:

the layout would be

col d col G

25.00 M
1.00 Z
5.00
3.00 M

So my answer would be $28.00

 

[Frank Kabel]

Hi
try
=SUMIF(G1:G100,"M",D1100)

 

[Jason Morin]

Did you ever try the formula I gave you?

Jason

-----Original Message-----
I want to count all the dollars found in the corresponding cells found in
column d ... where column G contains the character M:

the layout would be

col d col G

25.00 M
1.00 Z
5.00
3.00 M

So my answer would be $28.00







.

 

[Bardo]

You had it correct ... I was just not putting in the right information ...
thank you for your response ... it works.