SumIF Problem

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: SumIF Problem

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike T.
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default SumIF Problem

     
    Hi: Anyone tell me why this formula returns a blank cell?

    =SUMPRODUCT(('ET Database'!A2:A25='Emp Turnover'!B3)*('ET Database'!E2:E25='Emp Turnover'!G3)*('ET Database'!F2:F25="x"),'ET Database'!F2:F25)

    I copied the formula from this web-site and posted it.

    Database, Col A are months, such as Nov
    Col E are Unit Codes such as 3400
    Col F means a count of 1.

    Thanks
    0 0
     

  2. #2
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SumIF Problem

      
    Kristy
    0 0
     

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com