Sumproduct

[Forestq]

Hi,

In sheet I have two coulmn columns:

A = applications
B = sector

I set "define name" for the column:
A = "prod_web" (range: $A$2:$A$1000)
B = "sec" (range: $B$2:$B$10000)

When I want to sum how many specific applications have specific sector I did: =SUMPRODUCT((PROD_WEB="ABC")*(SEC=A2)) and works great

Now I want to check how many applications is in each sec, so i tried to do just: =SUMPRODUCT((PROD_WEB)*(SEC=A2))

but it's wrong.

Maybe should I do some count???

 

[Akashwani]

Hi,

Possibly.....

=SUMPRODUCT(--(PROD_WEB)*(SEC=A2))

You may want to take a look here, Mike has some great videos on SUMPRODUCT....

ExcelIsFun - YouTube

I hope that helps.

Ak

 

[Aladin Akyurek]

Hi,

In sheet I have two coulmn columns:

A = applications
B = sector

I set "define name" for the column:
A = "prod_web" (range: $A$2:$A$1000)
B = "sec" (range: $B$2:$B$10000)

When I want to sum how many specific applications have specific sector I did: =SUMPRODUCT((PROD_WEB="ABC")*(SEC=A2)) and works great

Now I want to check how many applications is in each sec, so i tried to do just: =SUMPRODUCT((PROD_WEB)*(SEC=A2))

but it's wrong.

Maybe should I do some count???

Depends on what kind of count you want...

=SUMPRODUCT(1-(PROD_WEB=""),--(SEC=A2))

Does this meet your intent?

 

[Forestq]

=SUMPRODUCT((--PROD_WEB)*(SEC=A2)) - doesn't work :/ I get error "Value"

I tried also =SUMPRODUCT((PROD_WEB)*(SEC=A2)) but it`s the same problem

 

[Forestq]

thank you Aladin Akyurek!

works great for me!!!

 

[Aladin Akyurek]

thank you Aladin Akyurek!

works great for me!!!

You are welcome.