Posted to microsoft.public.excel.worksheet.functions

windsurferLA windsurferLA is offline

external usenet poster

Posts: 50

array formula count results of two tests

Thanks.... I don't know why I didn't think of that... it works.

JBoulton wrote:
Try this:
=sumproduct(--(c3:c19="+/+"),--(f3:f19="blast"))

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
Inconsistent Array Count results	Suzanne	Excel Worksheet Functions	5	April 6th 06 05:02 PM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
abdualmohsn	almedrahe abdualmohsn ahmad	Excel Discussion (Misc queries)	1	November 19th 05 06:32 PM
Array	Brad	Excel Worksheet Functions	9	October 17th 05 09:00 PM
How can you use count with an array formula similar to using sum	PhilH	Excel Worksheet Functions	3	June 27th 05 08:00 AM

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

About Us

"It's about Microsoft Excel"