Ask Your Question
0

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

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

SilvioSiefke gravatar image

updated 2020-07-28 20:48:05 +0200

Alex Kemp gravatar image

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 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

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

Question Tools

1 follower

Stats

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

Seen: 52 times

Last updated: Feb 13