Excel Data recall - Specific line of data to be pulled to a different excel sheet.

[rquicktx]

Howdy all,

I just received a very extensive date sheet and I would like to pull only the lines of data pertaining to 2022 entries. There is a specific column which shows 2022 creation date.

So, what I need to do is run a query or a sum= type of statement which pulls only those rows where 2022 is shown in the column.

I appreciate the help.

Thanks,

RQ

 

[RobP]

Hi, welcome to the forum.

If I assume you have a column of Dates in Col A, and next to it your desired numbers to add in Col B.

A Formula like this would add only the numbers in Col B that had dates in Col A = "2022"

=SUM(FILTER(B1:B6,YEAR(A1:A6)=2022))

Is it what you need ?

 

[rquicktx]

I will give this a try and let you know. I have been trying various formulas, none seem to do the job I need it to do.

Thanks,
Rob