ExcelBanter - Another formula problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Another formula problem (https://www.excelbanter.com/excel-discussion-misc-queries/152688-another-formula-problem.html)

Lloyd

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?

T. Valko

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?

All times are GMT +1. The time now is 11:48 PM.