+ Reply to Thread
Results 1 to 2 of 2

Array formula not working - Please Help

  1. #1
    Registered User
    Join Date
    02-09-2007
    Posts
    1

    Array formula not working - Please Help

    I was wondering if I might be able to get some help here. I have a problem kicking my butt for days now and I can't figure it out. Here it is:

    I have a workbook containing a master worksheet and an additional worksheet to tally certain records from the master. I am using an array formula to do this but I can not get it to work when I try to define a whole column instead of a range.

    This works:

    {=SUM(IF('District Master'!E4:E216="Woodwinds",IF('District Master'!H4:H216="V-VI",IF('District Master'!D4:D216="S",1,0))))}

    This gives me a #NUM error:

    {=SUM(IF('District Master'!E:E="Woodwinds",IF('District Master'!H:H="V-VI",IF('District Master'!D:D="S",1,0))))}

    Any assistance would be greatly appreciated by myself and the hairs I haven't pulled out yet!

    Thanks!

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    It's not something in the first 4 rows ??

    Anyway I would of used a non array

    =SUMPRODUCT(--('District Master'!$E$4:$E$65000="Woodwinds")*('District Master'!$H$4:$H$65000="V-VI")*('District Master'!$D$4:$D$65000="S"))

    Note : With Sumproduct you can't select the entire column

    VBA Noob
    Last edited by VBA Noob; 02-09-2007 at 05:51 PM.
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1