If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C

rick10r · #1 07-03-2016, 10:21 AM

Hi All,

I want to create a formula that does the following:

If the value of cell (A) Matches a value in column B (vertical range) (all values in column B are unique), add value of cell C to the total in variable cell "D" (Cell D is a variable cell in column E in the same row as the row in which the matched column B value was found.

I think that is as clear as I can make it. I hope it is clear enough.

Thank you very much,

Rick

gebobs · #2 07-05-2016, 12:07 PM

That's about as clear as mud. ;-) Can you attach a sample sheet illustrating what it is you wnat?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search Range Within Cell or Cells	COEngineer	Excel	1	06-01-2016 11:50 AM
If id cell range is empty then should not allow to fill any other cell	ubns	Excel Programming	2	04-12-2015 06:31 AM
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?	alshcover	Excel	2	06-03-2014 12:50 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM