Hi,
I'm conducting a forecast & have a list of positions with estimated percentage or hours.
I'm looking to "count" prospective resources or individuals charging per week or during specified days - Monday through Sunday's.
For cumulative estimated hours I used:
=SUMIF($D$43:$D$84,"<>*Est*",C15:C56)
-- Finding "Est" as a key abbreviation to find & sum.
I'm looking to do something similar but I have unique positions & therefore can't use a key word abbreviation.
I attached a table for example.
Looking for solution in row 12
Bookmarks