Sum dependant on '1' value in another column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DL - 22 Jan 2006 04:07 GMT

Hi,
Let's say I have a '1' or nothing in column 'L' and a time in seconds in
column 'B'. The '1' means the time is a legitimate one. Can I do a sum of
all the 'legitimate' times in column 'B' based on whether there is a
corresponding '1' in column 'L'? Is there a formula that will allow me to
do that? Sorry for the ignorance of the question but it is late and I am
struggling to make this spreadsheet work for me.
Thanks in advance,
Dave

Reply to this Message

Norman Jones - 22 Jan 2006 04:18 GMT

Hi DL,

Look at the SUMIF function in Excel help.

Try:

=SUMIF(L1:L100,"=1",B1:B100)

Change the ranges to accord with your requirements.

---
Regards,
Norman

> Hi,
> Let's say I have a '1' or nothing in column 'L' and a time in seconds in
[quoted text clipped - 5 lines]
> Thanks in advance,
> Dave

Reply to this Message

Ron Coderre - 22 Jan 2006 04:19 GMT

Try this:
=SUMIF(L1:L100,1,B1:B100)

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

> Hi,
> Let's say I have a '1' or nothing in column 'L' and a time in seconds in
[quoted text clipped - 5 lines]
> Thanks in advance,
> Dave

Reply to this Message

DL - 22 Jan 2006 13:17 GMT

You guys are wonderful!! Thank you very much. I have been beating my head
against this one. Again, thank you very much.
Dave

> Try this:
> =SUMIF(L1:L100,1,B1:B100)
[quoted text clipped - 20 lines]
>> Thanks in advance,
>> Dave

Reply to this Message