how to count a score

Seifeddine87

Board Regular
Joined
Sep 7, 2015
Messages
100
9

hi i am trying to make an excel sheet to help me with my bisness
all what i want to do is to count the score of the cars i have sold
Exemple
in jan sheet i have sold 2 corsa 3 golf and 5 clio feb sheet i have sold 5 corsa 4 golf and 1 clio mar......
and each car i have sold i have rated it out of 5
i want in the last sheet to count the rating score for each model
i havent finish it incase if needed to change it
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Cant see your pic, but see if this is what you want...
A​
B​
C​
D​
E​
F​
1​
CarjanFebScore
2​
Corsa
2​
5​
Corsa
1​
3​
Clio
5​
1​
Clio
2​
4​
Golf
0​
4​
Golf
3​
5​
Score
12​
19​
B5=SUMPRODUCT(--($A$2:$A$4=$E$2:$E$4),(B2:B4),($F$2:$F$4))
copied across
 

Seifeddine87

Board Regular
Joined
Sep 7, 2015
Messages
100
Cant see your pic, but see if this is what you want...
A​
B​
C​
D​
E​
F​
1​
CarjanFebScore
2​
Corsa
2​
5​
Corsa
1​
3​
Clio
5​
1​
Clio
2​
4​
Golf
0​
4​
Golf
3​
5​
Score
12​
19​

<tbody>
</tbody>

B5=SUMPRODUCT(--($A$2:$A$4=$E$2:$E$4),(B2:B4),($F$2:$F$4))
copied across

thank you for your reply FDibbins if u click right click on the pic and go to open image in new tab should work
for each car i sell i give a rating score out of 5
for
Example
sheet Jan i have sold 2 clio and 3 golf. first clio i rate it 3 out of 5 and second clio rate it 2 out of 5. first golf 5 out of 5 second golf 3 out of 5 third golf 2 out of 5
sheet Feb i have sold 1 clio and 2 golf.
first clio i rate it 5 out of 5 and first golf 4 out of 5 second golf 5 out of 5
sheet total i have got all makes and models of the cars and front the clio total should be the average score what i have rated. clio will be 3.3 out of 5 and golf will be 3.9
 

Seifeddine87

Board Regular
Joined
Sep 7, 2015
Messages
100

ADVERTISEMENT

od4ewxyjn

this one from different web
hi i am trying to make an excel sheet to help me with my business
all what i want to do is to count the score of the cars i have sold
Example
WorksheetJan i have sold 2 clio and 3 golf. first clio i rate it 3 out of 5 and second clio rate it 2 out of 5. first golf 5 out of 5 second golf 3 out of 5 third golf 2 out of 5
Worksheet Feb i have sold 1 clio and 2 golf. first clio i rate it 5 out of 5 and first golf 4 out of 5 second golf 5 out of 5
Worksheet total i have got all makes and models of the cars and front the clio should be 10 and golf will be 19

i want in the last sheet to count the rating score for each model
i havent finish it incase if needed to change it
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,331
Office Version
  1. 2016
Platform
  1. Windows
Hi,

Your pictures are not showing up.
Read here regarding posting samples: http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2545970
Or, upload a sample to a file host of your choice, something like Dropbox: https://www.dropbox.com/

Maybe something like below to get started:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Car Sold</td><td style=";">Scores</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Clio</td><td style="text-align: right;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Clio</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Golf</td><td style="text-align: right;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Golf</td><td style="text-align: right;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Golf</td><td style="text-align: right;;">2</td></tr></tbody></table><p style="width:1.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Jan</p><br /><br />

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Car Sold</td><td style=";">Scores</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Clio</td><td style="text-align: right;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Golf</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Golf</td><td style="text-align: right;;">5</td></tr></tbody></table><p style="width:1.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Feb</p><br /><br />

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Car Sold</td><td style=";">Total Scores</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Clio</td><td style="text-align: right;;">10</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Golf</td><td style="text-align: right;;">19</td></tr></tbody></table><p style="width:3em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Total</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B2</th><td style="text-align:left">=SUM(<font color="Blue">SUMIFS(<font color="Red">Jan!B$2:B$100,Jan!A$2:A$100,A2</font>),SUMIFS(<font color="Red">Feb!B$2:B$100,Feb!A$2:A$100,A2</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Total Sheet B2 formula copied down.

If this doesn't help you, please refer to top of this post regarding posting samples.
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
I suggested you upload .jpg's instead of .png's, yet you just loaded more .png's?

Many are unanle to view those due to browser issues
 

Watch MrExcel Video

Forum statistics

Threads
1,122,187
Messages
5,594,748
Members
413,930
Latest member
Nela817

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top