Posted to microsoft.public.excel.worksheet.functions

z060081

external usenet poster

Posts: 3

Use SUMIF, VLOOKUP, HLOOKUP, LOOKUP, AND ??

Hi Bernard Liengme,

Really thanks a lot for the help... Appreciate a lot for the help..

Regards,

Bernard Liengme wrote:
None of the above but use SUMPRODUCT
=SUMPRODUCT((A2:A11=1001)*(MONTH(B1:F1)=12)*B2:F1 1)
best wishes
Hi,

[quoted text clipped - 38 lines]
11 1005 1 1 1 2
1

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
lookup combine vlookup with hlookup	Doug	Excel Worksheet Functions	2	April 23rd 23 11:42 AM
HLOOKUP, VLOOKUP, LOOKUP???	Connie Martin	Excel Worksheet Functions	10	October 23rd 08 06:02 PM
Help with Hlookup/Vlookup and Lookup. From multipul sheets	shonit	Excel Worksheet Functions	1	June 7th 07 05:53 PM
how can I use an hlookup in a sumif?	JMallo	Excel Worksheet Functions	2	December 21st 06 04:33 AM
I've tried Sumproduct, SumIf, Vlookup and Hlookup.	Steved	Excel Worksheet Functions	5	July 19th 05 11:46 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us