[Help] Excel help

[kevo]

While we are all awaiting the big news, can someone help me with this really simple Excel query. I need a formula which will give me the total number of W, D and L for Brazil from the following sample table. Should be easy, but it's doing my head in...

 

[Billy Seagull]

Do a pivot table.

 

[Hampster Gull]

While we are all awaiting the big news, can someone help me with this really simple Excel query. I need a formula which will give me the total number of W, D and L for Brazil from the following sample table. Should be easy, but it's doing my head in...
View attachment 99144

=3+1+3+0+0+1+3+0

 

[giveusfalmerplease]

google "excel sumif example"
actually countif..see below.

 

[giveusfalmerplease]

i didnt copy your data exactly but you can add some formulas - first column determines if brazil home or away - 2nd column then checks the respective column for the result and then the 3rd column sums up the w/d/l results

 

[akipling]

Not got excel at home but you need to use COUNTIFS

Have a look at https://exceljet.net/excel-functions/excel-countifs-function and if you haven’t sorted it by morning I’ll have a look

 

[kevo]

Not got excel at home but you need to use COUNTIFS

Have a look at https://exceljet.net/excel-functions/excel-countifs-function and if you haven’t sorted it by morning I’ll have a look

Yes, thanks - countifs works. Cheers