Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List File Properties - Author | Excel Worksheet Functions | |||
How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
Browse File for Mac | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions |