Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function with unknown quantities?
I'm trying to write a conditional formula to add hours spent performing
different roles for the same project by each of our staff members, but I'm hung up on how to represent the TRUE statement. Let's say all our project names are in the A column of a worksheet, but there may multiple rows of this project if a person works in different roles (column B) for the same project, so you'd have: COLUMN A COLUMN B COLUMN C Project: Role: Hours: Grant Analyzer Phase II Developer 5 Grant Analyzer Phase II Project Manager 3 So, I want to: 1) first find any rows that have the text "Grant Analyzer Phase II" in the A column, 2) then for those rows that do, add the values in Column C together 3) and display the sum on a different worksheet. I think I get the first part, but I'm not sure what references to use for the second part. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function with unknown quantities?
Try this...
Sheet2 A1 = Grant Analyzer Phase II =SUMIF(Sheet1!A:A,A1,Sheet1!C:C) -- Biff Microsoft Excel MVP "maudeq" wrote in message ... I'm trying to write a conditional formula to add hours spent performing different roles for the same project by each of our staff members, but I'm hung up on how to represent the TRUE statement. Let's say all our project names are in the A column of a worksheet, but there may multiple rows of this project if a person works in different roles (column B) for the same project, so you'd have: COLUMN A COLUMN B COLUMN C Project: Role: Hours: Grant Analyzer Phase II Developer 5 Grant Analyzer Phase II Project Manager 3 So, I want to: 1) first find any rows that have the text "Grant Analyzer Phase II" in the A column, 2) then for those rows that do, add the values in Column C together 3) and display the sum on a different worksheet. I think I get the first part, but I'm not sure what references to use for the second part. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown error in function, and how to return value? | Excel Worksheet Functions | |||
A function that looks for a value on a sheet on unknown column or row | Excel Worksheet Functions | |||
Different quantities of a certain item... | Excel Worksheet Functions | |||
IF Function - If the reference cell data is presently unknown | Excel Worksheet Functions | |||
Unknown IF function parameter on amortization schedule | Excel Worksheet Functions |