Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checking for a value, then summing corresponding columns 1

Status
Not open for further replies.
Stewman

Stewman

MIS
Jan 23, 2002
79
US
Hello,

I have a data set of two columns. Column A has values of 30, 45 and 60. Column B has various numbers. What I want to do is to have a formula in another field that checks column A for 60 and then sums up the numbers in column B that have 60 in Column A. I was trying to use an If statement and I can get it to check Column A but I can't figure out how to add the values in Column B together. Any help appreciated.

 
Sort by date Sort by votes
That was it. Can't believe I didn't think of that. Thanks for your help SkipVought
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
211
SkipVought
S
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
466
combo
combo
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
194
EFFEY
EFFEY
OCM
  • Locked
  • Question
Compare two columns
Replies
2
Views
873
OCM
OCM
E
  • Question
Copying spreadsheet for posting
Replies
2
Views
202
combo
combo

Part and Inventory Search

Sponsor

Back
Top