Sum dependant on '1' value in another column

D

DL

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
 
N

Norman Jones

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.
 
R

Ron Coderre

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

Adjust range references to suit your situation.

Does that help?

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

XL2002, WinXP-Pro
 
D

DL

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