# 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 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 29, 2010 at 03:16 PM
Not sure what you are looking for. On surface it seems that you want to use SUMIF
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 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

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
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Apr 3, 2010 at 08:46 AM