Adding if partial date string is matched

[Steven811]

Morning All

Sorry, having complete brain fade this morning and can't find an answer searching the forum either.

I have 2 columns

Column A contains a value
Column B contains a date eg displayed as 15/5/2012

In Column C I wish to display the value from Column A for all of the days in May 12

This will continue for the rest of the dates which are spread over a 12 month period. I can edit these accordingly.

Can't seem to fathom this.

Any help would be gratefully received.

Steven811

[Pepe Le Mokko]

Perhaps use a Pivot Table?

[dilipandey]

Hi Steven811,

If you need to add the values - lets say for the mont of May, you can use below formula:-

{=SUM(IF((B1:B14>=DATE(2012,5,1))*(B1:B14<=DATE(2012,5,31)),A1:A14,""))}

You need to adjust the range reference in above formula .. please press Ctrl Shift Enter key combination for above as that is an array formula.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Steven811]

Hi DILIPandey

Thanks for helping.

Basically I wish to extract values that relate to a particular month and display them in column C and they can be summed at the end.

I tried using =IF(B10="*" & "/05/12",C10,"") but couldn't get this to work

[Fotis1991]

Hi

Maybe somrthing like this?

=IF(MONTH(A1)=5,B1,"")

[Steven811]

Hi Fotis

Thank you. My problem is that the 5 is a partial string and I'm struggling to add the wild card syntax

I tried using =IF(B10="*" & "/05/12",C10,"") but couldn't get this to work

[Fotis1991]

...Column A contains a value
Column B contains a date eg displayed as 15/5/2012

In Column C I wish to display the value from Column A for all of the days in May 12

...I tried using =IF(B10="*" & "/05/12",C10,"") but couldn't get this to work

Steven, my poor English or(and) my Excel skills don't allow me to follow you...

Can you upload a small sampple workbook?

[Steven811]

Hi Fotis

Please see the example spread sheet attached.

The empty rows show where we need the data.

[Fotis1991]

Steven, try this

Please Login or Register  to view this content.

[Steven811]

Perfect

Thank you

[Fotis1991]

You are welcome!

[Pepe Le Mokko]

Nothing that a simple Pivot Table could not have done...