Count if or SumProduct
Is this what you had in mind:
Sheet1
...........A...........B
1....Model.....AMT
2.......x.............3
3.......z.............1
4.......x.............5
5.......y.............4
Sheet2
...........A...........B
1....Model.....Total
2.......x.............8
Enter this formula in Sheet2 B2:
=SUMIF(Sheet1!A$2:A$5,A2,Sheet1!B$2:B$5)
--
Biff
Microsoft Excel MVP
"Brandy" wrote in message
...
I have two columns : column A defines the make/model; column B numerically
defines how many were sold . Note: There are multiple entries for the
same
makes/models due to different territories.
I have a separate worksheet for which I need to summarize this info.
What would be the best formula for this task? I guess I am lost on what
to
enter to count.
Any help is greatly appreciated!
Thank you,
|