Posted to microsoft.public.excel.worksheet.functions

Iriemon

external usenet poster

Posts: 89

SUMPRODUCT

I am trying to create a formula to count the number of text entries in that
match two criteria. This is as far as I have been able to go. Both fields are
text.

=SUMPRODUCT('Main'!A1:A1884<"")*('Main'!C1:C1884= "STHHH")

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	scire	Excel Worksheet Functions	3	August 11th 06 08:04 PM
Sumproduct	sanders	Excel Discussion (Misc queries)	2	August 9th 06 11:05 AM
Sumproduct	Denise	Excel Discussion (Misc queries)	4	October 20th 05 02:09 AM
sumproduct	FLKULCHAR	Excel Worksheet Functions	1	September 18th 05 03:36 PM
Sumproduct.................	Kstalker	Excel Worksheet Functions	8	September 12th 05 11:04 PM

All times are GMT +1. The time now is 02:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us