[solved] Calc based on month(now)

[SilvioSiefke]

Hello,

I try to calculate prices based on month.

In column A4:A14 stand the date in format D.M.Y., in column B4:B14 stand the consumption.Now I try to calculate the price based on month(now) and column B4:B14 with price 0,279115.

I try it with =SUMPRODUCT(MONTH(A5:A15)=MONTH(NOW())C5:C15) but this will not work.

Is there a other way to handle it?

Thank you
Silvio

[keme]

You need a semicolon before the C5 reference.

Also, check that your dates are entered as real date values, not plaintext. What does the formula =MONTH(A5) return?

[SilvioSiefke]

Hi,

=MONTH(A5) = 2

Thanks
Silvio

[SilvioSiefke]

Hi,

there was a mistake in the formula.

=(SUMPRODUCT(MONTH(A$4:A$15)=MONTH(TODAY());C$4:C$15))*G$1

With this all work.

Silvio