Posted to microsoft.public.excel.misc

Lucifer

Posts: n/a

Formula not working -- =SUMIF($F$6:$F$91,"=90",G6:I91)

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Formula to find the working days difference between to dates?	Mudgeman	Excel Discussion (Misc queries)	2	May 15th 06 04:26 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Looking for a working production formula so I can add to staff?	JJL	Excel Discussion (Misc queries)	0	March 11th 05 04:11 PM
Formula entered not working	Thrava	Excel Discussion (Misc queries)	5	March 6th 05 09:18 PM

All times are GMT +1. The time now is 04:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us