hello All,
Please I need some help with writing a macro or using excel formula to get the sum of the data. I am working with a large set of data. It runs up to more than column CC. I will be able to continue once I get the foundation I want to be able to get the total for each day for each item in the result worksheet. I thought about using countifs but I have a lot of different response that I will need back Please how do I go about doing so using the Worksheet(working data) ? Pleassse I will really appreciate any help. Sorry for the long data sample thanks!!!! *Worksheet(working data)* DATE NAME RESPONSE BCOC detail O_PROGRAM BILL AMT type TYPE PGM 10/1/2016 WEST 116 STREET YES 6183109 FUEL2 AOPFUEL $869.02 HLD FUEL AOP 10/1/2016 AMSTERDAM AVENUE NO 6183109 ELEC AOPFUEL $993.48 HLD UTIL EAP 10/1/2016 AMSTERDAM AVENUE NO 6183109 FUEL2 AOPFUEL $1,234.42 HLD FUEL AOP 10/1/2016 AMSTERDAM AVENUE YES 6183109 FUEL2 AOPFUEL $551.97 HLD FUEL AOP 8/26/2016 AMSTERDAM AVENUE YES 6280423 ELEC EOP UTILITY $167.10 HLD UTIL EAP 8/27/2016 AMSTERDAM AVENUE NO 6280109 FUEL2 EOP UTILITY $2,629.27 HLD FUEL EAP 8/8/2015 AMSTERDAM AVENUE YES 6280109 FUEL2 EOP UTILITY $1,400.68 HLD FUEL EAP 10/1/2016 MANHATTAN AVENUE YES 6280109 FUEL2 EOP UTILITY $351.85 HLD FUEL EAP 10/1/2016 MANHATTAN AVENUE YES 6280109 FUEL2 EOP UTILITY $488.41 HLD FUEL EAP 8/7/2015 OLD BROADWAY YES S002423 ELEC EOP UTILITY $86.56 HLD UTIL AOP 8/7/2015 WEST 116 STREET NO 6280109 FUEL2 EOP UTILITY $1,252.10 HLD FUEL EAP 8/25/2016 WEST 116 STREET YES 6280109 FUEL2 EOP UTILITY $2,274.95 HLD FUEL EAP 10/1/2016 WEST 116 STREET YES 6280109 FUEL2 EOP UTILITY $1,535.80 HLD FUEL EAP 10/2/2016 WEST 119 STREET NO 6280423 ELEC EOP UTILITY $694.28 APR UTIL EAP 9/20/2016 WEST 119 STREET YES 6183109 FUEL2 AOPFUEL $245.58 HLD FUEL AOP *Worksheet(results)* result 8/7/2015 10/1/2016 9/20/2016 AMSTERDAM AVENUE RESPONSE(YES) RESPONSE(NO) ELEC FUEL2 EOP UTILITY AOPFUEL AOP EAP SUM_BILL_AMT AVERAGE_BILL_AMT -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.