DATA REFERENCE

  • Thread starter Thread starter Yuanhang
  • Start date Start date
Y

Yuanhang

Hi,
I have a spreadsheet showing my daily transactions that includes "Dates,
Amounts, and Purposes".
Now I would like to create some sort of table to check how many transactions
I made per month. Counting the number isn't hard for me. The most difficult
part is how to have it updated automatically for new transactions being
processed later on.
So basically, I gonna have two columns A and B:
Column A (Month to be counted) Column B (# of Trans)
Dec., 2007 23
Jan., 2008 11
Feb., 2008 09
Mar., 2008 16
<----New Row Added
and if there's any new data for March added in, there will be a new row down
there.

Is it possible to make that happen? Thank you very much.
 
Use COUNTIF() with the entire column that has the dates to match in it. I'll
try an example. Assume that the information to be counted is on Sheet1 with
dates in column C, and that your summary as shown in your post is on Sheet2.

In B1 (where you have 23 now), you could enter the formula:
=COUNTIF(Sheet1!C:C,A1)
in B2 (where you show 11) the formula would be
=COUNTIF(Sheet1!C:C,A2)
 
Back
Top