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

[NBPuts]

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!

 

[DILIPandey]

Hi NBPuts,

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


Regards,
DILIPandey

 

[NBPuts]

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.

 

[DILIPandey]

Hi NBPuts,

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


Regards,
DILIPandey