Posted to microsoft.public.excel.misc,microsoft.public.excel.programming

MJKelly

external usenet poster

Posts: 114

countif / sumproduct or something else?

Sandy sorted this out with sumproduct. I'll also try the possible
solution above too (again form Sandy), to see if it works or to see
how I might use this method in the future.

many thanks,
Matt

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Countif and Sumproduct	Sandy	Excel Worksheet Functions	4	August 18th 07 10:08 PM
Sumproduct and Countif together	[email protected]	Excel Discussion (Misc queries)	3	April 2nd 07 05:00 PM
COUNTIF or SUMPRODUCT	ThomH	Excel Discussion (Misc queries)	6	July 12th 06 05:40 PM
SUMPRODUCT/COUNTIF	luvthavodka	Excel Discussion (Misc queries)	12	June 17th 06 02:58 AM
Countif or Sumproduct	Harley	Excel Discussion (Misc queries)	8	December 22nd 05 12:34 AM

All times are GMT +1. The time now is 10:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us