Ask Your Question
0

[solved] Calc based on month(now)

asked 2020-02-12 09:32:44 +0200

SilvioSiefke gravatar image

updated 2020-02-13 23:39:35 +0200

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 flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2020-02-13 23:37:51 +0200

SilvioSiefke gravatar image

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

edit flag offensive delete link more
1

answered 2020-02-12 09:50:20 +0200

keme gravatar image

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?

edit flag offensive delete link more

Comments

Hi,

=MONTH(A5) = 2

Thanks Silvio

SilvioSiefke gravatar imageSilvioSiefke ( 2020-02-12 12:27:04 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-02-12 09:32:44 +0200

Seen: 39 times

Last updated: Feb 13