Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-15-2016, 10:27 AM
riothecat riothecat is offline Wanting to get data from one cell and and add the data from corresponding cell Windows 10 Wanting to get data from one cell and and add the data from corresponding cell Office 2007
Novice
Wanting to get data from one cell and and add the data from corresponding cell
 
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default Wanting to get data from one cell and and add the data from corresponding cell


I would like excel to find numbers in a range of cells. and then gather data from cells in the same row and add them up.

e.g.
cells b1 through b 15 contain a number example 1 2 3 2 5 3 4 2 6 3 4 1

cells c1 through c15 contain a currency number 2.45, 4.36, 3,21, 4.34 8.62 so forth and so on.

I need a function the takes the number in b1 through b 15 snd then look at the info in c1 through c15 and add the numbers in c1 through c15 for each corresponding cell in b1 through b15

b2 = 2and c2 = 4.36
b4 = 2 and c4 = 4.34

the output in another cell should be 8.70

is this possible?
sorry its so long but the best way to describe it, I tried...
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Move the data at bottom cell to right side of the cell kcyag91 Excel 1 01-28-2016 12:28 AM
Data validation,force cell to be filed with number if respective cell is not empty nicholes Excel Programming 0 08-01-2015 09:08 AM
How to replicate, consolidate and count cell data in excel for data consoldation. Loran Excel 7 06-05-2014 01:07 AM
Copying data from one cell to another where condition is third cell fairyca Excel 4 03-30-2014 08:22 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM

Other Forums: Access Forums

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


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