View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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