nmc1104

Posts: n/a

question about SUMPRODUCT

thanks! you guys are pros.

"Peo Sjoblom" wrote:

Assuming "and" means or in this case

=SUMPRODUCT((A1:A5={"manager","supervisor"})*(B1:B 5="present"))

--

Regards,

Peo Sjoblom

"nmc1104" wrote in message
...
I have a worksheet laid out like this

COLUMN A COLUMN B
manager present
supervisor absent
supervisor present
CEO absent
manager absent

How would I write a formula that would count every "manager" and
"supervisor" present?

thanks.

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
SUMPRODUCT Question	John Moore	Excel Discussion (Misc queries)	2	October 18th 05 12:31 PM
another sumproduct question	cjjoo	Excel Worksheet Functions	1	October 11th 05 03:43 AM
SUMPRODUCT Question...	PokerZan	Excel Discussion (Misc queries)	4	August 27th 05 12:09 AM
sumproduct question	Dominique Feteau	Excel Worksheet Functions	8	July 26th 05 08:43 AM
Question about sumproduct	Jason	Excel Discussion (Misc queries)	1	April 21st 05 05:44 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us