Prev: I need to unprotect sheet so I cn sve it but need a password?
Next: Combine 2 worksheet change events
From: steve on 28 May 2010 07:23
What does
=+SUMIF($G10:$G31,"Yes",I10:I31)
mean?
--
steve
From: Dave Peterson on 28 May 2010 07:59
=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
From: Jacob Skaria on 28 May 2010 08:00
SUM I10:I31 if G10:G31 = "Yes"

--
Jacob (MVP - Excel)


"steve" wrote:

> What does
> =+SUMIF($G10:$G31,"Yes",I10:I31)
> mean?
> --
> steve
From: bala_vb on 28 May 2010 10:50

steve;956738 Wrote:
> 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




--
bala_vb
 | 
Pages: 1
Prev: I need to unprotect sheet so I cn sve it but need a password?
Next: Combine 2 worksheet change events