Summing Columns Based On Value

S

stck2mlon

I have a spreasheet with 150 rows of entries. In the 8th column I have
different options that can be in it, i.e. Database, FOIA, Consulting
Events and Rent. These 150 rows are not sorted on the 8th coulmn no
can they be.

I would like a cell at the bottom of the worksheet that sums eac
group. The user needs up to the second data and doesn't have time t
resort and re SUM the fileds. I don't even know where to begin. An
help would be fantastic
 
T

Tom Ogilvy

=Sumif(H1:H150,"Database",I1:I150)

the range cited in the 3rd argument contains the values to be summed. The
first argument is where the condition is checked. If you mean you want to
count how many rows are labelled database

=Countif(H1:H150,"Database")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Update SUM formula after inserting rows 2
Couple subs need help with 2
Sum Columns with Specific Headings 6
this code is VERY slow, is it the code or perhaps a worksheet issue 32
Select and sum all numbered cells in Column A 2
Sum parts of a column 2
Summing conditional columns 1
Any experts on the "if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! 7

Top