Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
Hi,
I'm trying to get a count from excel based on certain criteria. The table i'm trying to get data from is similar to the below:-
<tbody>
</tbody>
The data above is populated by using VLOOKUPS on the numbers 1 to 5 from another sheet in the workbook.
What i need to try and do is say in cell A10, total the amount of the following (from column A it needs to = Simple, Column C needs to count all cells greater than Batch 74 (Batches run from 70 to 100 usually), and column D needs to = Hard.
I've tried various options but cannot get the formulas to work, not sure if it's because there are Pending and Holding in Column C.
I've tried a helper column converting column C to just display the right hand 2 digits but i still cannot get that to work correctly.
Any advice/help will be greatly appreciated.
Thanks.
I'm trying to get a count from excel based on certain criteria. The table i'm trying to get data from is similar to the below:-
A | B | C | D | |
1 | Simple | Simon | Pending | Easy |
2 | Simple | Gary | Batch 77 | Hard |
3 | Complex | Clare | Holding | Hard |
4 | Simple | Graham | Batch 77 | Hard |
5 | Complex | Paul | Batch 73 | Hard |
<tbody>
</tbody>
The data above is populated by using VLOOKUPS on the numbers 1 to 5 from another sheet in the workbook.
What i need to try and do is say in cell A10, total the amount of the following (from column A it needs to = Simple, Column C needs to count all cells greater than Batch 74 (Batches run from 70 to 100 usually), and column D needs to = Hard.
I've tried various options but cannot get the formulas to work, not sure if it's because there are Pending and Holding in Column C.
I've tried a helper column converting column C to just display the right hand 2 digits but i still cannot get that to work correctly.
Any advice/help will be greatly appreciated.
Thanks.