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

		Microsoft Office Forums > Microsoft Excel > Excel
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-03-2016, 10:21 AM

rick10r

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

Mac OS X

Office for Mac 2011

Novice

Join Date: Jul 2016

Posts: 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

Tags

formula, match

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:46 PM.