Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Thanks for the help with my last post.
Im using the following formula to sum column K when the corresponding number in column BE is between + - 50. AW122 houses -50 and AW123 50. =SUMIF(BE2:BE118,"="&$AW122,$K2:$K118)-SUMIF(BE2:BE118,""&$AW123,$K2:$K118) Now Id like to determine the sum for only the positive values in column K. If the number in column K is greater than 0 and a corresponding number in column BE is between + - 50, sum the number in column K. The sum in the example below would be 1 K BE -0.2 45 1 -43 0.3 54 Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
sumif to add data in multiple sheets | Excel Worksheet Functions | |||
Is it possible to specify multiple condition with SUMIF? | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Worksheet Functions |