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

Ron, thank you for your help. I tried to rate your post but did not know how
to do so. Instructions said it would be at the top or bottom of your post
window but I did not see anything.

Your post as well as the others are really helpful. Thank you.



"Ron Coderre" wrote:

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