Search : in
By :

Excel Formula

Last answer on Mar 6, 2009 1:25:08 pm GMT Dawn, on Mar 5, 2009 7:32:09 pm GMT 
 Report this message to moderators

Hello,

I wonder if somebody can help me with a pretty basic (I think) Excel formula. I would like for it to go through column A and search for a number - eg 5650T. If that number is in that field, I would like it to total the other columns in that row - eg D1:M1. I know this is simple but I've been struggling with it for hours and Excel help isn't helping me either.

Thanks!

Configuration: Windows Vista
Internet Explorer 7.0

Best answers for « Excel Formula » in :
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Excel formula to get the cell with the text Show
Excel Formula Display in Cell (Solved) Show
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Adding data from one column using another ShowAdding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Special characters ShowSpecial character codings HTML standards require all code to be written in 7-bit ASCII, which means that accented characters are not allowed. Despite this, current browsers recognise accented characters; you can enter accented characters directly...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

heavenlyz, on Mar 6, 2009 10:13:43 am GMT

I don't know if I got this right but the thing that you can do is to search for the number by using the CTRL+F keys and then the number you are looking for. After this you can now sum up the rows by writing the formulae =SUM(A1:Z1) or whatever you must enter in the field in which you should display the result and here you go.

   
Reply to heavenlyz

2

 Dawn, on Mar 6, 2009 1:25:08 pm GMT

Hi,

Thanks for trying but that isn't exactly what I'm looking for. In column A I have a whole series of numbers, with some of them coming up more than once. They also end up in different columns so I need the formula to say basically IF A1 (or A2, etc) has this number (5650T - there will be other numbers too that I have to put in seperate formulas) in it, add the colums for that row. I know there is a command but I'm having a hard time figuring it out. Maybe by bumping this thread somebody will know.........:)

The way you said it by using CTRL F, is the way I did it yesterday. It did work but that's very manual and time consuming.

   
Reply to Dawn
Ask your question Reply
They need your help