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?

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?