Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find topic for count
Hi,
After failing at solving my problem and even spending hours looking for solution on the forum, I thought its time to throw in the towel and ask for expert help. Situation: I want to write a code so that I can count a large data sheet - Monthly log report. Assumed: Column A: Date(day) since 05/2005 Column B: location (random Column C: Amount used I'm looking for a code that allow my search for the date range (month of June, 2005) with the location at L.A. and count or sume the amount total in column C. Can anyone direct to a related thread or help. Thank you, Thomas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find topic for count
Assuming your columns of data are all the same length you can use this formula Code: -------------------- =SUMPRODUCT((MONTH(A1:A10)=6)*(YEAR(A1:A10)=2005)* (B1:B10="L.A.")*(C1:C10)) -------------------- -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=567248 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |