IF funcition question

[Dallas6570]

OK I have one more and I am done with this spreadsheet.. I appreciate everyones help with this.

I need to total random cells in a single column.

Since I am not sure what the formula is I will spell what I want to do
A B C D
FALSE(formula) 193,700
NOT TRUE 182,800
FALSE 178,200
TRUE 195,500

I want to add all totals in column D that correspond to "False" in column B
These could be scattered throughout column D and not in order.

Basically I need to be able to put in a formula that looks at column B and says if the cell in cloumn B has false then sum the corresponding number in cloumn D with all other cells showing false in column B.

Does this make sense???

[NBVC]

Try:

=Sumif(B:B,FALSE,D:D)

[Dallas6570]

Thanks for the False formula, but I also need to do the same forluma with a true and it does not seem to work I keep getting 0 as the calculation?


Thanks

Dallas6570

[nattasiray]

Please attach the file or picture, it will help the volunteer understand

[Dallas6570]

Attached File shows my dilemma.

I want the formula to look for all "False" and total the amounts in column D that correspond to the "False in column B

I want to be able to do this with each catagory I have in Column B
False, True, Empty.


Thanks for all of your help

[Dallas6570]

In column A & B I have the following
Column A Column B
True 100
False 50
True 800
False 25

I am trying to create a formula that says Take all cells that have false in them in the entire A Column and add(sum) the corresponding numbers in Column B

I am doing this in a summary cell G4

Does this make sense.
See attached

[Dav]

TRUE and FALSE are the special values in excel, true is just text

sumif(B:B,"true",D:D)

may give you the answer, but having a mixture of FALSE and true is not a good idea

Does that help

regards

Dav