Posted to microsoft.public.excel.programming

external usenet poster

Posts: 14

Data Array Not Calculating???

Hello all,

Does anyone know why this formula does not work with range names?

{=MAX(IF(NAME=A2,TransAmount,""))}

This works fine however, I have to adjust the range when adding data.

=MAX(IF('P-card
data'!$E$2:$E$7284=A2,'P-card data'!$F$2:$F$7284,""))

Thank you for your assistance, Ron

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
Calculating % occurence of a value derived from data array	WildWill	Excel Worksheet Functions	2	October 17th 08 11:07 AM
Array Formula Not Calculating	Alex	Excel Worksheet Functions	1	April 12th 07 01:52 AM
Calculating percentile on array with 65536 elements	pinkfloydfan	Excel Programming	6	March 27th 07 12:15 AM
Calculating Median Value in a large array	willcozz	Excel Discussion (Misc queries)	5	December 11th 06 10:21 PM
calculating wtd number with conditional array formula	nacholibre	Excel Discussion (Misc queries)	4	October 20th 06 09:26 PM

All times are GMT +1. The time now is 08:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us