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
- If condition in excel - Guide
- Air condition lidl - Home - Apps & Sites
- Available memory less than 15mb condition zero - Guide
- Excel clear cell contents based on condition ✓ - Excel Forum
- If cell contains text then return value multiple conditions - 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
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
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