Microsoft Excel 2003

[ConfigQueen]

Help with a macro please.

I am trying to count the number of appointments per resource on a weekly basis. In have a number of regional worksheets with a named resource column and a appointment date column in each.

As COUNTIF does not support 3 dimensional referencing I have thought of using =COUNT(IF(logical_test,value_if_true,value_if_false)) using a number of logical tests (i.e name, date range) for each page. I am not getting it right.

Could anyone help me with this please.

 

[empip]

Absolutely sure you need a macro? Array functions are very powerful and underused.

There are many out there but I like this massive Excel resource :-
http://www.cpearson.com/excel/topic.aspx

See date and time stuff :-
http://www.cpearson.com/excel/datetime.htm#finding

Counting...
http://www.cpearson.com/excel/array.htm
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

Play and learn time..

 

[ConfigQueen]

Thanks Empip.

I have realised I am using an array function however it is the date referencing that I am failing on. Will now try using named cells for this.

Playing but not learning what I want to know

Love the pearson site.