Posted to microsoft.public.excel.worksheet.functions

mjones

external usenet poster

Posts: 86

How To Do This Array Function

Hi All,

I'm really guessing he

=SUM(IF($H$10:$H$16<"Done",($F$10:$F$16<$B$4)))

Of course it has the squiggly brackets.

I'm trying to add the total number of items in F10:F16 that are less
than B4 and are not showing as Done in column H.

Help would be much appreciated.

Thanks,

Michele

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
array function	birdsting	Excel Worksheet Functions	1	September 29th 06 02:06 PM
AND in an array function?	Vince	Excel Worksheet Functions	2	April 17th 06 05:46 PM
Array Function	John Michl	Excel Worksheet Functions	6	March 20th 06 03:16 PM
Is there an array function or something like it?	nyys	Excel Worksheet Functions	0	January 12th 06 07:47 PM
Help with an array function	malik641	New Users to Excel	4	June 10th 05 05:09 PM

All times are GMT +1. The time now is 10:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us