Posted to microsoft.public.excel.misc

smiths4

Posts: n/a

Formula to sum two cell values

Good morning all,

I need to find a formula that can give me a total from two different
columns. example...

Column A is Column C is
Doctor 1
Lawyer 2
Lawyer 2
Doctor 1
Lawyer 2
Doctor 2

And as a result I need the formula to tell me how many doctors have a "1"
rating.

Please help.

Thanks
smiths4

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
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
formula for named cell/range using cell values	alex	Excel Worksheet Functions	2	August 27th 05 06:44 PM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM

All times are GMT +1. The time now is 11:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us