Excel Help Needed

Twentymac · 31 Mar 2009 at 21:36

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

Twentymac · 31 Mar 2009 at 21:55

oh yeah i've just made a quick example table to show what i needed.

Twentymac · 31 Mar 2009 at 22:02

Ok say in sheet one if James and Peter were called and no one answered then i will choose "not answer" from the drop downs . then in sheet 3 i want it to show how many of which calls have been made

Twentymac · 31 Mar 2009 at 22:08

=COUNTIF(Sheet1!C2,not answer)

thats not right is it ?

Twentymac · 31 Mar 2009 at 22:24

Cheers for that mate its worked, but now im stuck on how you mean do it in 3 columns, i sort of know what you saying but dont know how to lay it out

Twentymac · 31 Mar 2009 at 22:32

cheers mate just copied the forumla from sheet 3 and pasted into my sheet 3 and it works fine !

Lifesafer !

Twentymac · 31 Mar 2009 at 22:44

exactly what Explicit did for me