If condition

Closed
Rana - Mar 29, 2010 at 01:23 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Apr 3, 2010 at 08:46 AM
Hi,
I have arange of data like below, I want to apply a formula that means if you find 10999,11019, and11039 in colume A , sum the related values for them in colume B

A B
10001 -45,778,867.06
10002 -35,990.66
10004 -19,866,040.00
10009 -65,680,897.72
10099 -65,680,897.72
10999 -65,680,897.72
11001 -534,276,172.21
11009 -534,276,172.21
11011 -265,889,160.17
11019 -265,889,160.17
11032 -800,000,000.00
11039 -800,000,000.00

4 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 29, 2010 at 03:16 PM
Not sure what you are looking for. On surface it seems that you want to use SUMIF
0
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
Mar 29, 2010 at 03:59 PM
Hello,

Try by typing the following SUM(IF()) array formula :

=SUM(IF(A2:A13={10999,11019,11039},B2:B13,0))

And press CTRL+SHIFT+ENTER to enter the formula as an array formula.

Best regards

0
Hellow,

it does not work
I have tried the following: = sumif(A2:A13;A7;B2:B13) as A7 = 10999
but how can repet it to have the other conditions
0
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Apr 3, 2010 at 08:46 AM
0