Posted to microsoft.public.excel.misc

external usenet poster

Posts: 304

Is there an equivalent of sumproduct but for count?

I have the following formla, but am look to do the same with "count". Thanks

=SUMPRODUCT(--('All Divisions'!A2:A3039="Eastern"),--('All
Divisions'!J2:J3039=30))

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
SUMPRODUCT, count & sum	Tasha	Excel Worksheet Functions	2	August 24th 07 05:32 PM
count if or sumproduct?	Suddes	Excel Discussion (Misc queries)	5	March 15th 07 12:20 PM
Excel equivalent of sql group by count	shikarishambu	Excel Worksheet Functions	2	October 31st 06 04:09 PM
WORKDAY() Function Equivalent with SUMPRODUCT()	George Ray	Excel Worksheet Functions	4	October 9th 06 04:04 PM
Count if and Sumproduct	Brento	Excel Discussion (Misc queries)	2	June 20th 06 09:05 PM

All times are GMT +1. The time now is 09:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us