Forum Discussion
Excel if true statement with add total sum
I am trying to write an if or vlookup statement so when i input a value in c2 through c49 and the column j2 through j49 is check it will add the totals to one column in r2. I am having trouble creat...
Hello
A job for SUMIF() or SUMIFS().
How do i account for the check box to be a "true"statement if checked to add the sum?
=sumifs(c2:c49????