| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Looking for a working production formula so I can add to staff? | Excel Discussion (Misc queries) | |||
| Formula entered not working | Excel Discussion (Misc queries) | |||
Hybrid Mode
