Summing

[tlynn]

I've got two rows:

The first, G7:G26 filled with text.
The second, H7:H26 is filled with numbers IE: 32098

so G7=Stuff and H7=12

I would like it to sum the values in H7:H26 only if the a cell in the G7:G26 range has the word "Things" in it. So...

G H
7 Stuff 2
8 Things 1
9 Stuff 2
10 Things 1

The total of the entire column H=6 as counted, but I would like only the items titled "Things" summed. This would mean that the total should be 2 for things only. I hope that I have explained this clearly enough...

Thanks in advance.

 

[cstimart]

Here's what I came up with...

put the following in each Cell
G6: "List"
H4: "List"
H5: "Things"
H6: "Number"

Then use the formula...

=DSUM(G6:H10,H6,H4:H5)

 

[tlynn]

Won't work simply because the both the G and H columns already have data in them, text and values respectively. I am adding in a cell at the bottom that needs to sum the value located in column H associated with any "Things" located in column G.

 

[pagrender]

Does this work for you:

=SUMIF(G7:G26,"Things",H7:H26)

 

[stnkynts]

=SUMIF(G1:G6,"Things",H1:H6)

Edit ranges accordingly

 

[tlynn]

Tried that and I get a value of "0" which at this point is not right. The total for the ranges should be 35962...I originally tried that exact formula and got the same thing, 0, and thought I was way off. However, it appears that I was thinking correctly...at least thinking the same way as everyone else.

Any other thoughts?

 

[cstimart]

Tried that and I get a value of "0" which at this point is not right. The total for the ranges should be 35962...I originally tried that exact formula and got the same thing, 0, and thought I was way off. However, it appears that I was thinking correctly...at least thinking the same way as everyone else.

Any other thoughts?

You need to change the ranges to fit your data.

=SUMIF(G1:G6,"Things", H1:H6)