Building Sum by Matching String

[guruk]

Hope my list below is still readable and you can help me.

I like to count for example in C3 all Numbers below from Line 4 in
Column C that match the the Month like described in the String at A3
(so all July 2006)

#################################
A B C D
1 Day Information Room 101 Room 102

2 June 2006 0.00 200.00(=sum??)
3 July 2006 127.00(=Sum ??)
--------------------------------------------------------
4 1 July 2006 paid Room bill 100.00
5 2 June 2006 200
6 3 July 2006 15.00
7 9 June 2006 44.00
8 4 July 2006 130
8 6 July 2006 12.00
##################################

For Info: Before line 4 all Numbers are Countings from the unlimted list
that starts from line 4. So how to get automaticly the right Sum like
in C3 when the Data starting from Line 4 are mixed in monthes.
When I like to write for example in Line 2 like in Demo June 2006
in C2 the Sum of all June 2006 Transactions should be counted.

Hope you can help
Regards
Chris

[Toppers]

Would this be OK?

=SUMIF(A4:A20,"=*June*",C4:C20)

=SUMIF(A4:A20,"=*July*",C4:C20)

Or if you want to get the month from (say A3) and A3 contains "June 2006"

=SUMIF(A4:A20,"=*" & LEFT(A3,FIND(" ",A3)-1) & "*",C4:C20)

HTH

"guruk" wrote:

>
> Hope my list below is still readable and you can help me.
>
> I like to count for example in C3 all Numbers below from Line 4 in
> Column C that match the the Month like described in the String at A3
> (so all July 2006)
>
> #################################
> A B C
> D
> 1 Day Information Room 101 Room 102
>
> 2 June 2006 0.00
> 200.00(=sum??)
> 3 July 2006 127.00(=Sum ??)
> --------------------------------------------------------
> 4 1 July 2006 paid Room bill 100.00
> 5 2 June 2006
> 200
> 6 3 July 2006 15.00
> 7 9 June 2006 44.00
> 8 4 July 2006
> 130
> 8 6 July 2006 12.00
> ##################################
>
> For Info: Before line 4 all Numbers are Countings from the unlimted
> list
> that starts from line 4. So how to get automaticly the right Sum like
> in C3 when the Data starting from Line 4 are mixed in monthes.
> When I like to write for example in Line 2 like in Demo June 2006
> in C2 the Sum of all June 2006 Transactions should be counted.
>
> Hope you can help
> Regards
> Chris
>
>
> --
> guruk
> ------------------------------------------------------------------------
> guruk's Profile: http://www.excelforum.com/member.php...o&userid=36192
> View this thread: http://www.excelforum.com/showthread...hreadid=559818
>
>