Sumproduct is definitely the way to go ... BUT ... this *does* make Sumif()
total more then one column:

=SUM(SUMIF(F6:F91,">=90",INDIRECT({"G6:G91","H6:H91","I6:I91"})))

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
news:64FDA034-302F-484D-B58D-61300FB3196D@microsoft.com...
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