Posted to microsoft.public.excel.worksheet.functions

Steve

external usenet poster

Posts: 1,814

countif or sumproduct ?

Thank you, but I don't know pivot tables yet.

"Ashish Mathur" wrote:

Hi,

You may create a pivot table. Drag title to the row area and column B data
to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steve" wrote in message
...
I have job titles in H2:H54 ( 10 various)
Some are occupied (names in B2:B34)
Some are vacant (B35:B54) nothing in B35:B54
I'd like a formula to count how many are occupied by title, and how many
are
vacant by title.

Thanks,

Steve

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
Countif Sumproduct	gjameson via OfficeKB.com	Excel Worksheet Functions	5	December 19th 08 07:44 PM
SumProduct and Countif	Nycole	Excel Worksheet Functions	5	February 19th 08 07:52 PM
Countif and Sumproduct	Sandy	Excel Worksheet Functions	4	August 18th 07 10:08 PM
SumProduct + CountIf	Sarah	Excel Discussion (Misc queries)	2	May 7th 07 09:17 PM
CountIf or sumproduct	timmulla	Excel Discussion (Misc queries)	1	January 18th 07 03:49 AM

All times are GMT +1. The time now is 03:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us