Results 1 to 4 of 4

Thread: Trying to use SumProduct with IF statement from different worksheet in same workbook.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Trying to use SumProduct with IF statement from different worksheet in same workbook.

    Hi,
    I am trying to get a count of only non-hidden cells from a new worksheet within the workbook for column b where column a says a specific phrase such as service. I have tried the below, but am not getting exactly what I need and the numbers are not accurate.

    =SUMPRODUCT(SUBTOTAL(3,OFFSET(Static!$B$1,ROW(Static!$B$1:Static!$B$2000)-ROW(Static!$B$1),0)),(Static!$B$1:Static!$B$2000=A9)+0)*(Static!$A$1:Static!$A$2000="service")


    Thank you!

  2. #2
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trying to use SumProduct with IF statement from different worksheet in same workbook.

    Hi NBPuts,

    Before applying this formula, is the data filtered on column A for the keyword "service" ?


    Regards,
    DILIPandey

  3. #3
    New Member
    Join Date
    Apr 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trying to use SumProduct with IF statement from different worksheet in same workbook.

    Quote Originally Posted by DILIPandey View Post
    Hi NBPuts,

    Before applying this formula, is the data filtered on column A for the keyword "service" ?


    Regards,
    DILIPandey


    Unfortunately not. I will have multiple fields with different values needed for what is in Column A.

  4. #4
    Board Regular DILIPandey's Avatar
    Join Date
    Jul 2013
    Location
    Dubai
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Trying to use SumProduct with IF statement from different worksheet in same workbook.

    Hi NBPuts,

    Can you upload a sample workbook to a public link and share that link ?


    Regards,
    DILIPandey

Some videos you may like

User Tag List

Tags for this Thread

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
  •