Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 34

Array Formula Assistance

{=SUM(('Aug 08'!$M$10:$M$438=Tina!A7)*('Aug 08'!$N$10:$N$438))}

I have the above formula in (Worksheet Tina) and I want to look up the
information in Column A of that worksheet to match information in (Worksheet
Aug 08) Column M and if the information matches to return the value in Column
N. I am not sure what I have done incorrectly can you please assist me.

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
Formula Assistance	tommo	Excel Discussion (Misc queries)	3	January 14th 09 04:01 PM
Formula Assistance	PhxlatinoboiÂ®	Excel Discussion (Misc queries)	2	July 25th 08 09:56 PM
Formula Assistance	tglstar	Excel Worksheet Functions	1	February 19th 08 10:25 PM
Index Array Formula Assistance	LJoe	Excel Worksheet Functions	0	August 20th 07 07:34 PM
Formula Assistance	Mharper	New Users to Excel	2	July 11th 07 08:10 PM

All times are GMT +1. The time now is 06:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us