View Single Post
 
Old 07-03-2016, 10:21 AM
rick10r rick10r is offline Mac OS X Office for Mac 2011
Novice
 
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