Count the number of cells that have a date

  cstirrat 15:13 24 Nov 2010
Locked

Hi,

Also, does anyone know how to count the number of cells that contain a particular date in excel, e.g. 31st Dec 2011 across a number of tabs in the same workbook?
C.

  GaT7 16:49 24 Nov 2010

Hold down the Shift key while right-clicking the tabs (worksheets) you want to search in (or, if you need to search in tabs that are not adjacent to one another hold, down the Ctrl key instead).

Then press Ctrl+F to bring up the search applet. Type in the date (as it appears in the cells), & click on Find All. You'll get the total number of times it appears in all the tabs in the status bar at below left.

Here's an example screenshot click here - I searched for something across 5 tabs & it turned out '283 cell(s) found' in the status bar. So the thing I was looking for appears 283 times. G

  VoG II 17:05 24 Nov 2010

With a formula you'd need to count them on each sheet then sum. For example in Z1 of each sheet

=COUNTIF(A:A,DATE(2011,12,31))

then on a summary sheet

=SUM(Sheet2!Sheet8!Z1)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?