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

You could write an array formula, but that can be annoying if other people
are going to use the worksheet who don't know how to work with arrays. So,
you can try adding two sumif functions:

=SUMIF(G6:G91,"90",H6:H91)+SUMIF(G6:G91,"90",I6: I91)Hope that helps.
--
ERR229


"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