If condition Closed

Question

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

rizvisa1 · Answer

Not sure what you are looking for. On surface it seems that you want to use SUMIF

aquarelle · Answer

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

rana · Answer

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 · Answer

Have a look here, may shed some light

https://www.ozgrid.com/Excel/sum-if.htm

https://www.mrexcel.com/board/threads/nested-sumif-or-sum-with-multiple-conditionals.79576/

https://docs.microsoft.com/en-us/office/troubleshoot/excel/logical-and-or-in-sum-if


Hope you can get something from those

If condition

4 responses

Similar discussions

Subscribe To Our Newsletter!