I would like to calculate the following number of data in sample_data.xlsx.
- The number of entries whose title starts with [good] and whose level is High
- The number of entries whose title starts with [good] and whose level is Ligh
- The number of entries whose title does not begin with [good] and whose level is High
- The number of items whose title does not start with [good] but whose level is Ligh
But there are some errors.
Help me please.SampleLinq.zip (19.3 KB)