Function with unknown quantities?

M

maudeq

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenating results of Conditional statement 5
Need some PWA help 0
looking up multiple values in an arrray 5
Mail Merge query 1
Problem with SET & REF function 0
search function 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
lookup using multiple criteria 4

Top