Posted to microsoft.public.excel.worksheet.functions

ryguy7272

external usenet poster

Posts: 2,836

How do I do a summation with text instead of numbers?

=SUMPRODUCT(--(A1:A10="x"))

Regards,
Ryan--

--
RyGuy

"Gary''s Student" wrote:

=COUNTIF(A:A,"x")
--
Gary''s Student - gsnu200770

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
Summation	[email protected]	Excel Discussion (Misc queries)	2	November 28th 07 05:12 PM
summation	ExcelQuestion	Excel Worksheet Functions	11	June 27th 07 02:28 AM
Summation Operator	LizM	Excel Worksheet Functions	3	July 10th 06 06:37 PM
Summation from a to b	jeblunk	Excel Worksheet Functions	3	December 4th 05 02:14 PM
How can perform a summation?	Leebo	Excel Worksheet Functions	5	August 23rd 05 04:38 PM

All times are GMT +1. The time now is 12:58 AM.

About Us

"It's about Microsoft Excel"