I need help creating a formula that pulls information from two columns.
I need help creating a formula from two columns on one sheet and pushed to the summary sheet/dashboard with the totals.
The first column is a drop down menu for the order status (New, Processing, Billing, Completed, and Cancelled) and the second column contains a check or is unchecked. I am counting the drop down menu list with the unchecked rows. I have tried several of the formulas shared in previous discussions, but none have worked. I am only getting errors with the formats I have used so far.
Help Article Resources
Check out the Formula Handbook template!