Excel help needed !

[Twentymac]

ok guys dunno if anyone knows how to help me but here it goes....

my problem is for a call logging system i want to try and make.

Sheet 1 - This is where all customer details will be listed
i have managed to make the data validation list from sheet two where the list data is.

Sheet 2 - This is where the drop down list data is

Sheet 3 - This is where the call log results i want to be added up into the numbers section by what ever is resulting in the sheet one drop downs

 

[Meeko]

Put this formula in sheet 3, cell B2 and then copy and past down for no sale and abusing

=COUNTIF(Sheet1!C$2:C$5000,Sheet3!A2)

EDIT : You could just get rid of Sheet2 and assign Sheet3 A2:A4 as your data validation.