Quick excel question

WPKenny

Resident Freddy
Joined
Dec 22, 2003
Messages
1,348
Having a bit of a dense day.

Can anyone tell me the syntax to get excel to add up a column of figures but only include the cell if the corresponding cell in another column = FALSE ?
 

Vae

Resident Freddy
Joined
Dec 23, 2003
Messages
1,181
Assuming B13 is the cell that will display FALSE and you want to add up C7:C12 and display 0 rather than FALSE as an answer if B13 is not FALSE then

=IF(B13=FALSE,SUM(C7:C12),0)
 

WPKenny

Resident Freddy
Joined
Dec 22, 2003
Messages
1,348
Thanks for the quick reply but it's not quite what I'm after.

I need all the figures in column E added together but exclude the figures where the value in column G = FALSE

Code:
Line1 : 3233223             FALSE
Line2 : 4342342423        FALSE
Line3 : 4342343434        TRUE
Line4 : 4443244             FALSE
Line5 : 43433                TRUE
Line6:  434344              TRUE

In this case it would only give me the sum of line3 and line5 and 6 only.
 

Vae

Resident Freddy
Joined
Dec 23, 2003
Messages
1,181
If the False/True column only displays TRUE or FALSE then

=SUMIF(B8:B13,TRUE,A8:A13) would work
 

Users who are viewing this thread

Top Bottom