View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Formula not working -- =SUMIF($F$6:$F$91,"=90",G6:I91)

SUMIF will only sum up one column or row, try this:

=SUMPRODUCT(($F$6:$F$91=90)*($G$6:$I$91))


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Lucifer" wrote:

This formula was designed for the following purpose, if data in column/row
F6-F91 are greater than or equal to 90 then sum all amounts in G6 thru I91
(that correspond with the equal/greater to 90.

What is being returned is only the sum of column G6-G91 only, so even though
the criteria is met for say F6 thru F25 I am getting only the sum of G6 thru
G25 and need the sum of G6:I25.

I hope this makes sense. Any help would be appreciated