Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 202

COUNTA Q

I am trying to create a function that adds up the number of instances
in D35:J35 that are greater than 1 (effectively where cells have a
value other than blank or 0) in all sheets between Start and End. Note
I 52 sheets between these two. The formula below doesn't produce the
result I'm expecting. Have I gone wrong?

=COUNTA(Start:End!D35:J350)

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
Counta	Darrell_Sarrasin via OfficeKB.com	Excel Discussion (Misc queries)	8	September 25th 08 08:10 PM
COUNTA()	Michell Major	Excel Discussion (Misc queries)	5	October 17th 06 03:34 PM
COUNTA AND	luvthavodka	Excel Discussion (Misc queries)	2	July 6th 05 12:07 AM
using COUNTA	DougMc	Excel Discussion (Misc queries)	4	May 30th 05 12:57 AM
COUNTA Function not working =COUNTA(C3:C69,"NH")	MikeinNH	Excel Worksheet Functions	2	November 8th 04 01:19 AM

All times are GMT +1. The time now is 08:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us