Posted to microsoft.public.excel.worksheet.functions

fab

external usenet poster

Posts: 6

I have the following issue with COUNTIF

Okay I have a consolidated workbook - I need to refer to a column in another
workbook and count what type that cell is ie: RSW, LCQ etc

Thats the easy part.

In the result cell I also need to refer to the colmun next to the RSW and
find out how many of those RSW's are 500 or under.

Please help

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
COUNTIF Function issue	Gweduc	Excel Worksheet Functions	5	July 30th 09 10:43 PM
Countif issue	Stuck	Excel Worksheet Functions	3	June 23rd 09 10:29 PM
SumProduct CountIF issue	JimG	Excel Worksheet Functions	5	August 3rd 08 06:20 AM
edit this =COUNTIF(A1:F16,"1-2")+COUNTIF(A1:F16,"2-1")	sctroy	Excel Discussion (Misc queries)	2	September 25th 05 04:13 AM
COUNTIF or not to COUNTIF on a range in another sheet	Ellie	Excel Worksheet Functions	4	September 15th 05 10:06 PM

All times are GMT +1. The time now is 12:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us