Need to sum a column if two cells in row are equal

[cynthiaorser]

I need help - I actually am trying to do two separate functions, but I
think the formula should be similar for both.

#1: I am trying to sum a column if two cells in each row are equal.
For example:

Date N. Hours D. Hours Total
Row1 1/1/2006 3 1 4
Row2 4/4/2006 2 2 2
Row3 8/19/2006 1 1
Row4 9/19/2009 4 4 4

I want to sum the "total" column for all rows that have "n hours" and
"d hours" equal.



#2: Using the same data example, I want to sum the "total" column if
the value in the "date" column is within the past 90 days.

Can anyone help? I would be ever so grateful!

TIA -
Cynthia

 

[Guest]

Try:

=SUMPRODUCT((B2:B5=C2:C5)*(D25))
=SUMIF(A2:A5,">"&TODAY()-90&"",D25)