Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another formula problem
Can anyone help?
What I want to do is enable a figure in column B to be shown if column L is filled in with a date. Eg. if L35 has a date in the cell, the figure in B35 is to appear. I want this rule for every cell lin column B and L. Eg. If (L35=date, then use figure in B35) + If (L36=date, then use figure in B36) etc. etc. = total number. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another formula problem
Try this:
=SUMIF(L:L,"0",B:B) -- Biff Microsoft Excel MVP "Lloyd" wrote in message ... Can anyone help? What I want to do is enable a figure in column B to be shown if column L is filled in with a date. Eg. if L35 has a date in the cell, the figure in B35 is to appear. I want this rule for every cell lin column B and L. Eg. If (L35=date, then use figure in B35) + If (L36=date, then use figure in B36) etc. etc. = total number. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula problem | Excel Worksheet Functions | |||
formula problem | Excel Worksheet Functions | |||
Formula Problem | Excel Worksheet Functions | |||
problem with formula | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |