I need a formula for a report
Need a count if formula and sum if for to look at certain sheet and populate another sheet:
EX. If I have a row that has a cell with certain name like Event1 then has appt set checkbox and sales amount
I want to count how many appointment set checkboxes there are with the name Event1
Also same example Sum a Sales amount if the row contains a name like Event1
Help Article Resources
Check out the Formula Handbook template!