I'm pretty sure this one is simple, but I'm having a hard time figuring out how to return something on a count based off a condition. I work at a company that I am building a database to process our RMAs out of, and for the team that process the RMAs, I want to display a count of how many of each type of device is going to be shipped that day. Every RMA is only in one of two states: Processing or Shipped. On the first image below, I'm counting the number of RMAs that are currently pending. I need to count how many of each device type is currently pending. I'm looking for something like: If [status]=pending,count [device_type]
I'm not sure if that is even a thing you can do with web forms (I'm going to move to a sharepoint front end early next year, so I'd like to keep everything web friendly)