counting check boxes for an order

System

This discussion was created from comments split from: Formula to Count Check Boxes in a Check Box Column.

Ian McGlaze

Hey @Andrée Starå , I am having some issues counting check boxes for an order. I have attached 3 photos for reference. I want to get a total number of each device I need to order. I've been grinding formulas for 3 hours with no luck. Any help would be much appreciated.

Multiple Check Boxes .jpg

Reference Sheet.jpg

Order Total.PNG

Thanks for your time

Leibel S

@Ian McGlaze

See below, replace the bolded area with your cross sheet reference name

=COUNTIFS({READY TO ORDER RANGE},HAS(@cell,[Primary Column]@row))