Posted to microsoft.public.excel.worksheet.functions

A.Mourice[_2_] A.Mourice[_2_] is offline

external usenet poster

Posts: 3

sumproduct text

Hello,

A1 A,B,X,C,X
A2 X,D,G,X
A3 F,G,K,L,X

I need to count how many X repeated at many cells using sumproduct function.

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
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t	zzxxcc	Excel Worksheet Functions	2	August 26th 08 11:04 PM
Text in SUMPRODUCT	J. Trucking	Excel Worksheet Functions	5	March 12th 08 12:18 AM
sumproduct text if	mass	Excel Worksheet Functions	8	November 26th 07 03:44 PM
maybe by sumproduct or some other way with text.	driller	Excel Worksheet Functions	4	June 5th 07 08:54 AM
SUMPRODUCT vs Text???	Ken	Excel Worksheet Functions	2	April 9th 05 07:21 PM

All times are GMT +1. The time now is 06:19 PM.

About Us

"It's about Microsoft Excel"