Counting qty per specified type of condition

LJ Fernandez

Hi All,

I wanted to count the qty per type of Item description with condition that is filed as "request" in the column named "Type of request" ....how to do it?

Example: I wanted to count the quantity of all "Prefab Aluminum Rack" with "Request" as Type of request.

Thank you in advance. ;)

Andrée Starå

Hi @LJ Fernandez

I hope you're well and safe!

Try something like this.

=COUNTIFS([Type of Large Asset]:[Type of Large Asset], Description@row, [Type of Entry]:[Type of Entry], "Request")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @LJ Fernandez

I hope you're well and safe!

Try something like this.

=COUNTIFS([Type of Large Asset]:[Type of Large Asset], Description@row, [Type of Entry]:[Type of Entry], "Request")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

LJ Fernandez

Hi @Andrée Starå,

Thank you for your prompt respond. However, I figured it out after 2 hours of reviewing and understanding how the formula works.

Used same formula you sent ;)

Regards,

LJ

Andrée Starå

@LJ Fernandez

Excellent!

Happy to help!

Happy that you figured it out!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!