Building Sum by Matching String
 

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

Building Sum by Matching String
 

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