# [solved] Calc based on month(now) [closed]

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

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-07-28 20:49:03.582767

Sort by » oldest newest most voted

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

more

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?

more

Hi,

=MONTH(A5) = 2

Thanks Silvio

( 2020-02-12 12:27:04 +0200 )edit