associate employee #1 to #'s in next column & add total

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

Andrew

Emp is in column A; Copies in column B; Date column C;
Cost column D; Total for that month in column G.

I want to add the total # of copies that employee #1 uses
for the month and enter the total # in column G. I
basically want to figure out a way for excel to claculate
only the total # of copies (column B)from that month
(column C) for that one employee (column A).

Can anyone help me out please?
Thank you,
Andrew
 
Hi
try something like
=SUMPRODUCT(--($A$1:$A$100="employeename"),--(MONTH($C$1:$C$100)=1),--(
YEAR($C$1:$C$100)=2004),$B$1:$B$100)

for the moth January/2004
 
I used the formula you recommended in G4 where I want my
result to show and it shows #value! whether I put a value
in b4 or not. I am using columns G-V to represent all of
the months including quarters. G4-V4 will have the total
cost for each month. So starting with G4 I want it to add
all of cells in column D that are in the first month. In
order to do this I need the cost in column D to be
associated to the date in the previous column (C). I was
able with someones help to get the cell in column C to
show today's date when data is put in the cell adjacent in
column B. I also have two other columns Total spent column
E & Total Remaining column F. I managed to make the
correct formulas for these two. Can you help me with a
formula to make G4 add only those costs in column D that
were in the month of July and put that total in G4?
Thank you so much,
Andrew
 
Hi
try the following:
=SUMPRODUCT(--(MONTH(C1:C100)=7),--(YEAR(C1:C100)=2004),D1:D100)
 
Back
Top