Posted to microsoft.public.excel.worksheet.functions

vreeckes

external usenet poster

Posts: 1

CountIfs

I'm looking to get a count by using two selection criteria. So far I've used
this formula and have not been successful.

=COUNTIFS('Column Integration'!Z2:Z17,"2", 'Column
Integration'!T2:T1082,"Recommended")

Basically I want a count of all fields that are "Recommended" and have a
value of "2".

Thanks for any help anyone can provide.

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
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr	Steve	Excel Worksheet Functions	2	January 4th 09 05:36 PM
COUNTIFS	Skinman	Excel Worksheet Functions	3	December 11th 08 05:29 AM
Countifs	Diane	Excel Worksheet Functions	1	November 21st 08 09:43 AM
Countifs Fx in 07 how in 03?	HenderH	Excel Discussion (Misc queries)	19	March 26th 08 12:37 PM
countifs	Forza MIlan	Excel Discussion (Misc queries)	2	July 4th 07 09:48 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us