D Dave Peterson May 28, 2010 #2 =SUMIF($G10:$G31,"Yes",I10:I31) (You don't need the + Look at each cell in G10 to G31 (all 22 cells) If the value in each cell is Yes, then add up the value in the corresponding cell in column I (I10:I31)
=SUMIF($G10:$G31,"Yes",I10:I31) (You don't need the + Look at each cell in G10 to G31 (all 22 cells) If the value in each cell is Yes, then add up the value in the corresponding cell in column I (I10:I31)
B bala_vb May 28, 2010 #4 steve;956738 said: What does =+SUMIF($G10:$G31,"Yes",I10:I31) mean? Click to expand... a good description of sumif function with example, refer to below url http://www.techonthenet.com/excel/formulas/sumif.php all the bes
steve;956738 said: What does =+SUMIF($G10:$G31,"Yes",I10:I31) mean? Click to expand... a good description of sumif function with example, refer to below url http://www.techonthenet.com/excel/formulas/sumif.php all the bes
