Count if or SumProduct
Hi,
Try this. The lookup value is in A1 of the currebt sheet
=SUMPRODUCT((Sheet1!A1:A20=A1)*(Sheet1!B1:B20))
Mike
"Brandy" wrote:
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,
|