Posted to microsoft.public.excel.misc

The BriGuy[_2_] The BriGuy[_2_] is offline

external usenet poster

Posts: 16

Counting from multiple columns

I am looking for a formula to count instances, from multiple sheets, where
criteria in one column and another column occur. For example I have 4
worksheets and I amd looking for all instances where column A in all books
=Suzie Smith AND where column C in all books = Tuesday. Any ideas?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Counting rows based on multiple columns	Doyle	Excel Worksheet Functions	1	September 29th 06 07:06 PM
Counting in two columns	PedersenJ	Excel Worksheet Functions	3	August 8th 06 12:24 AM
Counting values in multiple columns	Emily	Excel Discussion (Misc queries)	2	May 14th 06 03:34 PM
Help w/ counting multiple columns based on IF criteria	ConstructionGuy	Excel Worksheet Functions	3	November 8th 05 04:03 AM
counting columns	jpcblood	Excel Worksheet Functions	1	August 10th 05 12:41 AM

All times are GMT +1. The time now is 12:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us