Countifs formula for either two condition

  • Thread starter Thread starter ansuman1985
  • Start date Start date
A

ansuman1985

I have a excel like this


Location ID Activity % completion

1. ABC LHS Shifting
Lifting 0%
Fixing

RHS Shifting
Lifting 100%
Fixing

2. DEF LHS Shifting
Lifting 100%
Fixing

RHS Shifting
Lifting 100%
Fixing

3. GHI LHS Shifting
Lifting 0%
Fixing

RHS Shifting
Lifting 0%
Fixing


I want to count the locations where lifting is 100% (irrespective of whether its LHS or RHS). in the above example the result should be 1,1 7 0 respectively.

Thank you in advance.
 
hi,

could you explain in detail how you did your calculation to find 1170?

isabelle

Le 2014-06-17 08:21, (e-mail address removed) a écrit :
 
Back
Top