Use date values from another sheet in a formula

Question

I have two sheets in my excel file.
The first sheet contains values and dates, and in the second I want to calculate values between a range of dates.

for example:
50 20/9/2014
1600 16/10/2014
254 21/10/2014
1547 03/11/2014

(Belgian time)

I tried it with the following formula:

=SUMIFS(INPUT!$G$3:$G$100; INPUT!$H$3:$H$27; ">=01/10/2014"; INPUT!$H$3:$H$27; "<=31/10/2014")

This gives me an error in the formula and I notice that inside the values of the formula, the date has become a random value:

enter image description here

Anyone have an idea how to do this correctly?

+3

Filip Huysmans Dec 22. 14 at 13:46

1 answer

CustomX · Accepted Answer · 2014-12-22T14:13:24+0000

I couldn't find it either, but it seems like your ranges should be the same size (sum_range and criteria)

.

So change your sum_range to G3:G37

or your criteria range to H3:H100

and it will solve your problem. :)

Use date values ​​from another sheet in a formula