Sumproduct

Hi everyone,

Please could someone help me out with a SUMPRODUCT question?

The first tab I have a summary sheet which I want to auto populate with a sumproduct function, the second tab is where the dates and values are I wish to sum the value if it’s returned in January

I had a go to try sum the entire range see below but it’s not working

=SUMPRODUCT(--('Alex Guest - Scotland'!$G$19:$G$1048576>=1/1/2009),--('Alex Guest - Scotland'!$G$19:$G$1048576<=3/1/2009),--('Alex Guest - Scotland'!$H$19:$H$1048576))

The ultimate goal I am trying to achieve is if there is a date in January in the date returned column and the php column does not contain a value I want it to sum in the summary sheet in January

Hopefully if anyone can advise that would be great then I can look at the formula and try workout to sum only if there is a value in the php column in January

Thanks in advance