Counting in Excel

  • Thread starter Thread starter Angel160
  • Start date Start date
A

Angel160

We use a spreadsheet to log deals executed. I need to count the numbe
of deals executed in a particular month.

The deals are logged by trade date written as dd/mm/yy.

I have tried Countif but this does not work for a range of data (fo
example 01/09/04 to 30/09/04).

Can anyone help?

Thank
 
Try some things.
First of all, see if thr format of cells (menu format cells) are dat
with the form dd/mm/year.
If this does not work, a pivot would solve your problem
 

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

Similar Threads

Count Dates between Dates exclude Text 3
Count Between dates 11
Access Count dates within a Month 4
How to count the occurrence? 3
How to count days in excel 2
Change from mm/dd/yy to yy/mm> 3
Count the number of items received in a certain month 1
Counting Cells with Multiple Range Criteria (Excel 2003) 7

Back
Top