|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C
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 |
#2
|
|||
|
|||
That's about as clear as mud. ;-) Can you attach a sample sheet illustrating what it is you wnat?
|
Tags |
formula, match |
|
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 |