software

I wasnt sure exactly how to word this question but i have an excel sheet
with 2 cullumns
|23|34|
|24|56|
|23|34|
|24|56|
|23|34|
|24|56|
|23|34|
|24|56|
|23|34|
|24|56|
|23|34|
|24|56|

now the actual one is more complicated but say i want to sum only the
numbers on the right hand size where the number on the left handsize is
23 how could i do this??
i had trouble searching the forums cause i couldnt really word the
question properly.
Thanks for your help

Max--
shalombi
------------------------------------------------------------------------
shalombi's Profile: www.hightechtalks.com/m899
View this thread: www.hightechtalks.com/t2352985First set of data in A1:12
Second set of data in B1:B12

In C1 type: =SUMIF(A1:A12,quot;=23quot;,B1:B12)

Hans
thank you, im not used to excel and the syntax is throwing me off a
bit.
Id rather use a good old for with a bit of incrementing and some
sentinel values it just seems all so simplier
anyway thanks alot.

Max--
shalombi
------------------------------------------------------------------------
shalombi's Profile: www.hightechtalks.com/m899
View this thread: www.hightechtalks.com/t2352985
how can i add multiple possibilities ?
i tried separating by commas, or, || and all i knew from programing and
it didnt work.
=SUMIF(E2:E547,quot;=391quot;,H2:H547)
if i want to have also lets say 58 in their

=SUMIF(E2:E547,quot;=391,58quot;,H2:H547)
i tried many different things and none worked

Max--
shalombi
------------------------------------------------------------------------
shalombi's Profile: www.hightechtalks.com/m899
View this thread: www.hightechtalks.com/t2352985Hi,

the comma is a list separator which is a local Windows setting
(regional and language settings). Try replacing it with a semicolon or
lookup your settings in Windows.

For multiple selections I have set up a simple example below:

Data in A2:B10
Selection criteria in E2:I2
Total in D3
Formulas in E3:H3

groupnumberstotalcond1cond2cond3cond4insert new cols bevor this
green32greenredyellowmagentano entry
magenta16219324510339
magenta23
red12
red33
yellow6
yellow53
yellow44
add rows before this

Formula in D3: =SUM($E$3:$I$3)
Formula in E3: =SUMIF($A$2:$A$10;quot;=quot;amp;E$2amp;quot;quot;;$B$2:$B$10)
Copy formula in E3 to F3:H3

Mind that the ranges are fixed which means that for new rows with data
insert the number of lines required befor the row that reads quot;add rows
before thisquot;. This line is included in the range.
Similarly add columns for additional conditions before the column that
reads quot;insert new cols before thisquot; because this column is included in
the range. If you insert new conditions don't forget to copy the
formula from the preceding cell into the new ones.

If this still isn't the solution please come back.

HansTry this:

=SUM(IF(E2:E547={391,58},H2:H547))
this is an array formula so enter it using CTRL SHIFT ENTER

HTH
JG

quot;shalombiquot; wrote:

gt;
gt; how can i add multiple possibilities ?
gt; i tried separating by commas, or, || and all i knew from programing and
gt; it didnt work.
gt; =SUMIF(E2:E547,quot;=391quot;,H2:H547)
gt; if i want to have also lets say 58 in their
gt;
gt; =SUMIF(E2:E547,quot;=391,58quot;,H2:H547)
gt; i tried many different things and none worked
gt;
gt; Max
gt;
gt;
gt; --
gt; shalombi
gt; ------------------------------------------------------------------------
gt; shalombi's Profile: www.hightechtalks.com/m899
gt; View this thread: www.hightechtalks.com/t2352985
gt;
gt;


Thank you all very much,

I appreciate the help.
keep up the good work

Max--
shalombi
------------------------------------------------------------------------
shalombi's Profile: www.hightechtalks.com/m899
View this thread: www.hightechtalks.com/t2352985How about a *non* array formula:

=SUM(SUMIF(E2:E547,{391,58},H2:H547))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;pinmasterquot; gt; wrote in message
...
gt; Try this:
gt;
gt; =SUM(IF(E2:E547={391,58},H2:H547))
gt; this is an array formula so enter it using CTRL SHIFT ENTER
gt;
gt; HTH
gt; JG
gt;
gt; quot;shalombiquot; wrote:
gt;
gt; gt;
gt; gt; how can i add multiple possibilities ?
gt; gt; i tried separating by commas, or, || and all i knew from programing and
gt; gt; it didnt work.
gt; gt; =SUMIF(E2:E547,quot;=391quot;,H2:H547)
gt; gt; if i want to have also lets say 58 in their
gt; gt;
gt; gt; =SUMIF(E2:E547,quot;=391,58quot;,H2:H547)
gt; gt; i tried many different things and none worked
gt; gt;
gt; gt; Max
gt; gt;
gt; gt;
gt; gt; --
gt; gt; shalombi
gt; gt; ------------------------------------------------------------------------
gt; gt; shalombi's Profile: www.hightechtalks.com/m899
gt; gt; View this thread: www.hightechtalks.com/t2352985
gt; gt;
gt; gt;