how to count a score

S

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

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
 
S

Seifeddine87

Board Regular
Joined
Sep 7, 2015
Messages
100
FDibbins said:
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
Click to expand...

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
 
S

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

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

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
 
You must log in or register to reply here.

Similar threads

T
  • Solved
Golf Scoring Formula - possibly IF statement
Replies
8
Views
431
Peter_SSs
Peter_SSs
P
  • Question
Custom Golf Handicaps
Replies
5
Views
174
jimrward
jimrward
T
  • Question
Cumulitive scores across multiple sheets
Replies
1
Views
108
cooper645
cooper645
C
  • Question
Score sheets - select names once per sheet & produce running total from all score sheets
Replies
3
Views
500
craigey1
C
A
  • Question
How to count the optimal number?
Replies
6
Views
117
areq09
A

Watch MrExcel Video

Learn Excel 2010 - &quot;Next Invoice Number&quot;: Podcast #1505

Forum statistics

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

Share this page

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