Posted to microsoft.public.excel.worksheet.functions

Dav

Posts: n/a

vlookup and countif???

Sumproduct does not work with column references, If your first row is
column headings replace.

E:E with e2:e65536 should your range need to be this long, an similarly
for K:K

Regards

Dav

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=520293

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 11:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us