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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2016, 10:21 AM
rick10r rick10r is offline 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 If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C Office for Mac 2011
Novice
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C
 
Join Date: Jul 2016
Posts: 1
rick10r is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-05-2016, 12:07 PM
gebobs gebobs is offline If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C Windows 7 64bit If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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

Tags
formula, match

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C Search Range Within Cell or Cells COEngineer Excel 1 06-01-2016 11:50 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C 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
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C 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


All times are GMT -7. The time now is 08:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft