Function help
 

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


--
drawlings
------------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626
View this thread: http://www.excelforum.com/showthread...hreadid=563719

Function help
 

drawlings wrote:
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


--
drawlings
------------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626
View this thread: http://www.excelforum.com/showthread...hreadid=563719

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

Function help
 

Thanks a bunch. Worked like a charm


--
drawlings
------------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...o&userid=36626
View this thread: http://www.excelforum.com/showthread...hreadid=563719