Count Unless?? - ExcelBanter

Posted to microsoft.public.excel.worksheet.functions

PCM

Posts: n/a

Count Unless??

I am using Excel 2000 and need to count the incidents of a defined value in a
column unless another defined value occurs in a different column in the same
row. For example, count the value "FAM" in column $A2:$A100 unless the value
"Cancelled" appears in the same row in column $B2:$B100.

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
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	2	March 20th 06 02:29 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	8	May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	8	February 3rd 05 01:37 AM

All times are GMT +1. The time now is 01:20 AM.

Menu

About Us