monthly total from associating cost & date in two columns

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Column B4 is # of copies. Column C4 is the date entered.
Column D4 is the cost of the copies. Column G4 is the
total for the month.
Request #1 I would like column C4 to stamp today's date
when numbers are entered in column B4.

Request #2 I would like column G4 to add the totals from
Column D4 but only for that month. So all of the cells in
column D4 adjacent to the cells that are stamped for that
month in Column C4 are totaled and that total is put in
Column G4.

I want to know the total cost of copies for the month at
any given time. So that the user only needs to put in the
# of copies.
Thank you,
Andrew
 
Hi
Reguest#1: See http://www.mcgimpsey.com/excel/timestamp.html

Request#2: See your other post using SUMPRODUCT for this. Though You
name only a cell (e.g. C4) but are talking about a column. So I'm not
so sure what you want to toal. Maybe you can post some example data
rows (plain text - no attachment please) and describe your expected
result based on this example
 
Back
Top