Posted to microsoft.public.excel.worksheet.functions

Joe

Posts: n/a

vlookup and countif???

help I am trying to write a formula that says the following.

if coloum a = main and if coloum b = yes please count the yes's

I have tried using vlookup and count if but I just get a null value returned

hope there is somebody there who can help

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
Forget SUMIF, COUNTIF and VLOOKUP	Pierre Leclerc	Excel Worksheet Functions	16	April 27th 23 11:51 AM
Countif + vLookup: Can they work together?	Spyder	Excel Discussion (Misc queries)	3	February 24th 06 12:27 PM
Countif or Vlookup	praveen_khm	Excel Worksheet Functions	1	February 3rd 06 08:17 PM
Countif? or Vlookup? Lost??	leo	Excel Worksheet Functions	3	November 30th 05 02:17 PM
vlookup, sumif, if, countif, help	chintu49	Excel Worksheet Functions	0	May 26th 05 03:00 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us