Sum If Help

M

Maggie0507

I need to have a total cell for a large spreadsheet I'm working on (150+lines
of data). I need to put in a formula that will add the amount in Column B if
the word in the Column A says "Retail".

Example:
A B
Retail 10,950
Storage 6,500
Retail 5,000
Retail 4,000
Storage 3,500

Total Retail Amount
Total Storage Amount


Relatively new to Excel, so any help would be greatly appreciated!!!
 
R

Reitanos

Try
=SUMIF(A2:B1000,"Retail",B2:B1000)

The first argument is the range of data
The second is the the text to target
The third is the part of the data to be used in the sum
 
M

Maggie0507

Thank you - worked like a charm!

Reitanos said:
Try
=SUMIF(A2:B1000,"Retail",B2:B1000)

The first argument is the range of data
The second is the the text to target
The third is the part of the data to be used in the sum
Click to expand...
 

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

SUMIFs function 2
SumProduct using Date Range 1
RUNNING TOTAL 7
Formula Help 3
Ranking Question 3
Index/Match - Lookup based on multiple column criteria 3
Using SUMIF to add data between a range of dates 2
Overwriting a cell with a formula without deleting the formula 1

Top