WaqasTariq
Board Regular
- Joined
- Jun 26, 2012
- Messages
- 54
- Office Version
- 365
I have two columns in Excel:
<tbody>
</tbody>
(66/2 = 33, 30/1 = 30, 93/3 = 31, 102/3 = 34, 180/5 = 36, 155/5 = 31) > 32 count = 10
Question: I want to count how many resources work over 32 hours in cell C3. Is there a formula in Excel that will help me do that?
Column A | Column B | ||
Res Qty | Total Hrs | ||
2 | 66 | ||
1 | 30 | Res over 32: | 10 |
3 | 93 | ||
3 | 102 | ||
5 | 180 | ||
5 | 155 | ||
... row #57 | ... row #57 |
<tbody>
</tbody>
(66/2 = 33, 30/1 = 30, 93/3 = 31, 102/3 = 34, 180/5 = 36, 155/5 = 31) > 32 count = 10
Question: I want to count how many resources work over 32 hours in cell C3. Is there a formula in Excel that will help me do that?
Last edited: