Matthew S

Posts: n/a

Array Formula

I'm working through an Excel text book (Benchmark Series). There is a
question (Concept Checks- Chapter E3 #16) that asks, "What is wrong with the
following array formula:"

{=SUM(IF(A5:I5=B5:B10,1,0))}

I set all the cells to a value of 5 and the formula returns a 54, which I
think is correct. Does anyone see anything wrong with the formula?

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
array formula	Jonathan Cooper	Excel Discussion (Misc queries)	4	September 9th 05 12:27 PM
#VALUE! On An Array Formula Referencing a Range Outside The Workbo	paige	Excel Discussion (Misc queries)	5	September 9th 05 12:05 AM
problem with Array Formula	OrdOff	Excel Worksheet Functions	2	June 30th 05 04:57 PM
Trouble shooting#NA error in Array formula	RonR	Excel Discussion (Misc queries)	2	June 14th 05 09:58 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM

All times are GMT +1. The time now is 07:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us