Need a conditional SUMIFS formula

Jewelle W

Hello,

I have 2 grids

Grid A: Project Management (used for team planning and communication)

Screenshot of Grid A

Grid B: Invoicing sheet (used for billing clients).

I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is not checked and put that sum in a cell on Grid A.

Currently this formula works: =SUMIF({Invoice Sent Check Box}, =1, {Task 1}) and its giving me the total of 30 (2 sent boxes are checked for rows of task 1, there is a 15 in each of those rows, 15+15=30) but I am trying to re-work the formula so that it excludes rows that have the "Void" column from Grid B checked (my real answer should just say 15 because there is only 1 row with the Sent column checked AND Void unchecked.

I attempted SUMIFS formulas: with this format: SUMIFS(range, criterion_range1, criterion1, [criterion_range2, criterion2, ...]). Assuming that range in the formula means the range to be summed and then listed my 2 criteria in the formulas below

=SUMIFS({Task 1}, {Invoice Void Checkbox},=0,[{Invoice Sent Check Box},=1])

and

=SUMIFS({Task 1}, {Invoice Sent Check Box}, =1,[{Invoice Void Checkbox},=0])

but both say "unparseable".

I am hoping that I am close but I am not sure where I went wrong. Please help!

Nic Larsen

Looks to me like you have brackets in there you don't need.

=SUMIFS({Task 1}, {Invoice Void Checkbox}, 0, {Invoice Sent Check Box}, 1)

Jewelle W

@Nic Larsen Thank you! That's exactly what I needed!