Thread: how do I use a range in conditional sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default how do I use a range in conditional sum
One way:

=SUMPRODUCT(--($F$16:$F$61=100),--($F$16:$F$61<=199),
--($K$16:$K$61=1), $I$16:$I$61)

See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of
the "--"


In article ,
cliff3466 wrote:

I am trying to use a range of numbers to determeine a condition for adding
amounts in a column. I am using the following,

=SUM(IF($F$16:$F$61="100",IF($K$16:$K$61=1,$I$16:$ I$61,0),0))

but were "100 is I would like to be able to include any number from 100 to 199

is this possible, and if so, how can I do this?
Reply With QuoteReply With Quote