Function help:function to calculate

[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

dan

[Bondi]

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

[drawlings]

Thanks a bunch. Worked like a charm