Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to sum cells in a sheet based on matching criteria in a row and
matching criteria in a column. The data that I am working with is represented as: Resource: Resource1 JAN JAN JAN JAN FEB Project Project Description 12/19 12/26 1/2 1/9 1/16 Admin Administration 10 10 10 10 10 Holiday Holiday 8 8 Other Other time Off Training Training 20 Vacation Vacation 22 30 10 30 22 I am looking to create a separate sheet that is a summary of this information. I want to match on the project (column A) and the Month (Row 1), where the project from the detail resource sheet matches the project from the summary sheet and the month from the detail sheet matches the month on the summary sheet, I want to summ the hours. I have tried several iterations of the SUM(IF), SUMIF, and SUMPRODUCT and I either get all cells that match a project, regardless of the month or I get errors in the formula. Help!!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add cells using a diffrent column as the criteria | Excel Discussion (Misc queries) | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
how can I average more cells only in a column by a criteria? | Excel Worksheet Functions | |||
Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
add a column only if 5 other cells on the row satisfy criteria | Excel Worksheet Functions |