how to count a score

[Seifeddine87]

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

 

[FDibbins]

Cant see your pic, but see if this is what you want...

	A​	B​	C​	D​	E​	F​
1​	Car	jan	Feb			Score
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]

Cant see your pic, but see if this is what you want...

	A​	B​	C​	D​	E​	F​
1​	Car	jan	Feb			Score
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]

 

[jtakw]

Double posted: http://www.mrexcel.com/forum/excel-...t-score-not-unique-name-different-sheets.html

 

[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

Sorry no, I am not able to view .png pics, try uploading as .jpg

 

[Seifeddine87]

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]

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:

Excel 2010
	A	B
1	Car Sold	Scores
2	Clio	3
3	Clio	2
4	Golf	5
5	Golf	3
6	Golf	2
Jan

Excel 2010
	A	B
1	Car Sold	Scores
2	Clio	5
3	Golf	4
4	Golf	5
Feb

Excel 2010
	A	B
1	Car Sold	Total Scores
2	Clio	10
3	Golf	19
Total

Cell Formulas
Range	Formula
B2	=SUM(SUMIFS(Jan!B$2:B$100,Jan!A$2:A$100,A2),SUMIFS(Feb!B$2:B$100,Feb!A$2:A$100,A2))

Total Sheet B2 formula copied down.

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

 

[Seifeddine87]

thank you for your reply jtakw
i hope the images will work this time
https://www.dropbox.com/s/teshntvszww1k4r/11.png?dl=0
https://www.dropbox.com/s/pqleztg396h410m/22.png?dl=0
https://www.dropbox.com/s/7ih8r5atq29ymyk/33.png?dl=0
https://www.dropbox.com/s/2uuj0kxj1dppp7u/44.png?dl=0
https://www.dropbox.com/s/gaxariiiuhdfo3f/55.png?dl=0

 

[FDibbins]

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