sumif based on 1 criteria

  • Thread starter Thread starter v1rt8
  • Start date Start date
V

v1rt8

cannot quite figure this out,
Cells a3:a1000 have respectively numbers 1-997
Cells f3:f1000 has text containing either of 4 types
(signed)(unsigned)(committed)(uncommitted)

lets say my name is jim and that name is in cell a492 and in cell f492 is
committed, i want to find how many people are above me that are committed.

is it a =sumif or another formula
 
if it helps in cell a1001 returns my number of 492
so xxx-492=#of people above me that are committed
 
Back
Top