i need help with a formula please. my current formula looks like this..
=SUMIF(Stage:Stage, ???, [Job Value]:[Job Value])
i need an answer to the ??? please as it is a column that has a formula in it that relates to other fields and is a check box. if true then tick the check box.
i am now wanting to sum the value of all of the checked box rows in my sheet.
Help Article Resources
Check out the Formula Handbook template!