I would like to move sum A1:A6 If the B cell is = True and another cell is = 1.

I have an attachment that shows the layout.

Therefore Total = 76.7

Does that make sense? If so how could i work out the formula?

i have =SUMIF(B1:B6,TRUE,A1:A6)

But how do i add the second criteria

Ok i did it using an array

=SUM((B1:B6=True)*(C1:C6=1)*A1:A6)

To Enter the array press Ctrl Shift Enter when leaving the cell.

Hope this helps anyone who came across the same problem.

That's one way to do it. Another is to use SUMPRODUCT, which is not an array function.

=SUMPRODUCT((B1:B6="True")*(C1:C6=1),A1:A6)