jdanniel2020
New member
- Joined
- Feb 2, 2020
- Messages
- 6
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel 2016
Hello, I'm using Excel/Office 365 and have a question about Power Queries.
I want a sheet that can contain any or all of the following information. I'm not sure (yet) how to do this.
1) A count of everything in the "Amount" column that is between $80.00 and $90.00.
2) A count of everything in the "Amount" column that is $80.00 or more.
3) A count of everything in the "Amount" column that is $90.00 or more.
Can I create a Power Query with one, some, or all of these three criteria? If so, what would be the best procedure for creating this?
If it's easier to do this some other way, i.e. with formulas, what would be the best procedure for that?
Attached to this message is the spreadsheet. Thank you! Jd
I want a sheet that can contain any or all of the following information. I'm not sure (yet) how to do this.
1) A count of everything in the "Amount" column that is between $80.00 and $90.00.
2) A count of everything in the "Amount" column that is $80.00 or more.
3) A count of everything in the "Amount" column that is $90.00 or more.
Can I create a Power Query with one, some, or all of these three criteria? If so, what would be the best procedure for creating this?
If it's easier to do this some other way, i.e. with formulas, what would be the best procedure for that?
Attached to this message is the spreadsheet. Thank you! Jd