Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date formulas | Excel Discussion (Misc queries) | |||
Picking out a Period, in relation to certain cells | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
split combined Time Date cells | Excel Discussion (Misc queries) |