• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

How to find values in excel and return matching numbers in same column

I am working in Microsoft Excel, and in one row I have cells with "R" that represent reconciled columns and cells that have either "*" or is blank. I want excel to find all the cells with "*" and blanks and return the sum of the matching columns.  Can someone tell me the formula to do this? I have attached an image to show what I am talking about
excel.jpg
0
beemmer
Asked:
beemmer
2 Solutions
 
jppintoCommented:
Use a SUMPRODUCT() formula, like this:

=SUMPRODUCT((B1:B6<>"R")*(C1:C6))

Please take a look at the attached file.

jppinto
Sumproduct-Example2.xlsx
0
 
Rory ArchibaldCommented:
Assuming the 'R's in column A and the values in B:

=SUMIF(A:A,"<>R",B:B)

will sum up column B where the corresponding cell in A is not 'R'

HTH
Rory
0
 
beemmerAuthor Commented:
Thank you both very much.  I tried out both of the formulas and they worked perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now