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
|