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
|