ExcelBanter - Argument description

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Argument description (https://www.excelbanter.com/excel-discussion-misc-queries/264789-argument-description.html)

Steve

Argument description

What does
=+SUMIF($G10:$G31,"Yes",I10:I31)
mean?
--
steve

Dave Peterson

Argument description

=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)

steve wrote:

What does
=+SUMIF($G10:$G31,"Yes",I10:I31)
mean?
--
steve

--

Dave Peterson

Jacob Skaria

Argument description

SUM I10:I31 if G10:G31 = "Yes"

--
Jacob (MVP - Excel)

"steve" wrote:

What does
=+SUMIF($G10:$G31,"Yes",I10:I31)
mean?
--
steve

bala_vb

Quote:

Originally Posted by steve (Post 956738)

What does
=+SUMIF($G10:$G31,"Yes",I10:I31)
mean?
--
steve

a good description of sumif function with example, refer to below url

http://www.techonthenet.com/excel/formulas/sumif.php

all the best

All times are GMT +1. The time now is 07:17 AM.