Welcome to the Forum grazey!
HLOOKUP will not give you what you want, which is why we encourage people to describe their problem rather than what they think the solution is.
First, your dates should be Excel dates, so hopefully that's what your data is in row 1 (A is a column, not a row).
Where in your data does it indicate that you want the sum for January? Suppose you have 1/1/2020 in cell C1. The formula to sum row 2 for January would be
If this does not help solve your problem please see yellow banner at the top of the page and attach your file.
Bookmarks