Calculating a column if 2 checkboxes are ticked

[wackyracer8]

What I am trying to do is add up all the prices when the paid checkbox is ticked and the just eat checkbox is ticked. I just can't seem to get to grips with it.

I'd also like to be able to say how many just eat are paid and how many are not paid but again I keep getting errors when using the IF statement.

Can someone please help me?

 

[wackyracer8]

I'd also like to be able to say how many just eat are paid and how many are not paid but again I keep getting errors when using the IF statement.

I've managed to solve this by using =COUNTIF(N3:N32,TRUE) but I'm still having trouble with the first one

 

[wackyracer8]

I'm trying to use =SUMPRODUCT(($O$3:$O$9=TRUE)+$A$3:$A$32) to get the desired result but it's producing a #N/A error in the cell.

 

[wackyracer8]

ok so I think I'm getting closer but I've obviously got something slighty wrong as I'm not sure how to add 2 true checkbox selections. I'm trying =SUMIF(N3:N8,"=true",((R3:R8,"=true"),A3:A32) but its throwing the "the formula you typed as an error)