View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cynthiaorser@houston.rr.com is offline
external usenet poster
 
Posts: 1
Default Need to sum a column if two cells in row are equal

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