Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add all values in a given row (not colum)?
i am trying to search colum "A" for all values equal to something, say all
the cells that have '1000' as their data, and then add up all the cells in the corresponding row, so if A34, A50, and A56 all have 1000 in them, then I want to return the value of all the cells added up in the rows, say B34,50,56 : K34,50,56 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add all values in a given row (not colum)?
Enter with Ctrl-Shift-Enter (an array formula)
=SUM(IF(A1:A100=1000,B1:K100)) Change range to suit "xenxander" wrote: i am trying to search colum "A" for all values equal to something, say all the cells that have '1000' as their data, and then add up all the cells in the corresponding row, so if A34, A50, and A56 all have 1000 in them, then I want to return the value of all the cells added up in the rows, say B34,50,56 : K34,50,56 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add all values in a given row (not colum)?
Or how about =SUMPRODUCT(--($A$1:$A$56=1000)*($A$1:$A$56)+(--($A$1:$A$56=1000)*($B$1:$B$56)+(--($A$1:$A$56=1000)*($K$1:$K$56)))) -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561845 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add all values in a given row (not colum)?
What's wrong with simply using:
=SUMPRODUCT((A1:A100=1000)*B1:K100) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "VBA Noob" wrote in message ... Or how about =SUMPRODUCT(--($A$1:$A$56=1000)*($A$1:$A$56)+(--($A$1:$A$56=1000)*($B$1:$B$5 6)+(--($A$1:$A$56=1000)*($K$1:$K$56)))) -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561845 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add all values in a given row (not colum)?
Sorry I read it wrong I thought he just wanted Col B and K not all of them VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561845 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding zero values in charts | Charts and Charting in Excel | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
comparing colum data and exporting | Excel Discussion (Misc queries) |