COUNTIF with several criteria

[Akbarov]

Hey Dear community,

I have very big data, where i need to count income based on markets, but there are some group of markets in my list with different names, i have already grouped them. ( for example N-market 1 , N-market 2 , N-market 3 )

So all N-markets are in A2:A10

How can i ask excel to sum total income of markets listed in A2:A10 ?

income is in D:D

 

[shaowu459]

=SUM(SUMIF(C:C,A2:A10,D:D))

Ctrl+Shift+Enter

 

[Akbarov]

Thanks for reply but not working :/

 

[shaowu459]

please describe your original data clearly, or upload a picture of your data, including row and column headers.

 

[Akbarov]

Incomes are in E:E
All Market names are in D:D
Names of markets starting with N-market 1 , N-market 2 , N-market 3 are in A2:A10

List is very huge is there any other way instead of array?

 

[shaowu459]

=SUM(SUMIF(D:D,A2:A10,E:E))

apply Ctrl shift enter, not just enter

 

[Akbarov]

it works thank you very much, but is there any way without array?

 

[shaowu459]

use a helper column maybe a better way.

B2=SUMIF(D:D,A2,E:E)

copy formula down to B10, and in B11 enter:=sum(B2:B10)