Sum question

  • Thread starter Thread starter Bardo
  • Start date Start date
B

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.
 
In your case, SUMIF will do just fine:

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

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

HTH
Jason
Atlanta, GA
 
Sumif would work if all the characters were M, but there are other
characters as well.
 
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
 
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?
 
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
 
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







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