Assistance with array formula please




I'm trying to calculate monthly outputs for a given set of people.
The sheet (Main) contains the Name (column E) and the Date (column G).
Users enter all the main details onto the 'Main' sheet. What I need to
do is to be able to calculate the number of times a users' name
appears during a certain period (Date1,Date2). This formula:


works (TRUE) for one cell reference only, but as soon as I add a range
to the formula:


the result is FALSE. If I try and add another AND section to reflect
the name I'm looking for:




that makes no difference. I've got a feeling that array formulas are
the answer here? but for the life of me I can't seem to get this to
work. All info and help in resolving this will be greatly appreciated.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question