IF...AND...VLOOKUP?? I'm not sure. Can someone please help me!

I have a spreadsheet with one column (Column B) showing all the months' names (like this: Jan, Feb, Mar, etc.) based on the date input in a previous Column A. In other words: Column A has dates put in this format "03/14/01", the next Column B shows these months' name and is Custom formatted like this "mmm" and it is using this formula: =TEXT(A2,"mmm"), =TEXT(A3,"mmm"), =TEXT(A4,"mmm"), etc..
The next Column C has some positives and some negatives numbers.
Now, in the Column D, I would like to have the numeric results based on a month. Let's say for the month of January what number in Column C will correspond to, or what number in Column C will correspond to month of February, and what number in Column C will correspond to month of March, etc..
Each month in Column A (or B) exists more than once.
I have tried IF and then IF(AND, VLOOKUP but with no success.

Can someone please help me with that problem.
Thank you.

Could you attach sample sheet, or an image at least?

If you want to COUNT or SUM then look at COUNTIF(S) or SUMIF(S) functions

e.g SUMIF(B1:B100,"Jan",C1:C100)

to extract monthly figures, you can use the INDEX/AGGREGATE functions

As requested please post a file - NOT image.

in G6

=IFERROR(IF(INDEX($C$2:$C$23,MATCH($F6,$A$2:$A$23,0))>0,INDEX($C$2:$C$23,MATCH($F6,$A$2:$A$23,0)),""),"")

copy across to H

copy dpwn

To JohnTopley.
Thank you so much, this is genius, however in the column H, I'm getting also positive values and not negatives.
Can you please look in that?

Thank you again.

To JohnTopley.
I have modified your formula a bit (to get negative numbers), but still some data is missing in the column H. See attachment.
For example, there are TWO identical dates for March 3/12/22 and one of them has value positive 16, and other other negative -18. Since those two data has been taken
very same day, but were taken at different times, looks like the problem is in there, isn't it?
If so, how it should be modified? Modify the dates with exact time with minutes and seconds and then apply this formula again?
Any suggestions?

Thank you

Try

=IFERROR(INDEX($C$2:$C$23,AGGREGATE(15,6,ROW($A$1:$A$100)/($A$2:$A$23=$F6)/($C$2:$C$23>0),COUNTIF($F$2:$F6,$F6))),"")

=IFERROR(INDEX($C$2:$C$23,AGGREGATE(15,6,ROW($A$1:$A$100)/($A$2:$A$23=$F6)/($C$2:$C$23<0),COUNTIF($F$2:$F6,$F6))),"")