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
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Apr 3, 2010 at 08:46 AM
Related:
- If condition
- Add if condition in excel - Guide
- Excel if condition color cell - Guide
- Excel copy row if condition met ✓ - Excel Forum
- If cell contains date then conditional format - Guide
- Copy rows based on a condition ✓ - Excel Forum
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
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
5961
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
February 14, 2026
491
Mar 29, 2010 at 03:59 PM
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
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
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
Apr 3, 2010 at 08:46 AM
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
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
