Function help

D

drawlings

Hi all,

I need some help with a worksheet function.

I have 2 columns. Col 1 contains Values and Col 2 contains True/False

I need a function to calculate the total value of col 1 where col 2
false.

Any ideas

Thanks

da
 
B

Bondi

drawlings said:
Hi all,

I need some help with a worksheet function.

I have 2 columns. Col 1 contains Values and Col 2 contains True/False

I need a function to calculate the total value of col 1 where col 2 =
false.

Any ideas

Thanks

dan
Click to expand...

Hi Dan,

Maybe you can use SUMIF.
If your data is in column A and B then something like this:

=SUMIF(B1:B10,FALSE,A1:A10)

Regards,
Bondi
 
Top