Counting Orders

[mjrichards]

Hi,

I was wondering if someone could help me figure out how to count the sale orders I have. Right now, I am manually entering both order information and then updating the order in a profit analysis sheet. Essentially, I want to be able to count each time an item appears in the sheet and then have it return the quantity sold that's in the next column to the profits analysis sheet.

I have column for quantity sold for the profits analysis in sheet 1 column G
The column for the item ordered is in sheet 2 column D
The column for the quantity of the item ordered is in sheet 2 column E

Thanks in advance for any help,
Matt