Sum column total from another sheet if checkbox checked

Josh R

Hi, I've seen this done on same sheet but I'm having trouble accomplishing my goal trying to pull from another sheet.  

What I'd like to do is on "New Sheet 1" have the "Done" Column total update from the "To Do" Column from "New Sheet 1b" when the checkboxes are checked.

Thanks in advance!

 

Josh R

Here's how it looks on the same sheet:

=SUMIF(QC1:QC3, 1, [To Do]1:[To Do]3)

I haven't been able to reference the 2nd sheet to make this work yet

Paul Newcome

There are a couple of ways to do this. You can either do the match on the source sheet and use a basic cell link, or you can use formulas with cross sheet references.

 

Just click on the text for each of the options for more information on how to use them.