<?xml version="1.0"?>
<rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
							<channel><title>New Posts For Thread: excel experts help</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help</link><description>wife is doing a spreadsheet , she has 2 columnscolumn A is the date and the same date may have 100s numerical values entries in column B, she wants in column C to average all values in B that correspond to the sme date in column A, what formula would</description><item><title>Thankyou Thankyou ThankyouIt does indeed work ( except for the comma in LEFT(.... )I had just got there myself in a similar way by using an intermediate column H and setting with  =DAY(A1) and then ammending the SUMIF to=IF(H1=H2;"";SUMIF(H$1:H1;H1;B</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469077069#469077069</link><description>Thankyou Thankyou ThankyouIt does indeed work ( except for the comma in LEFT(.... )I had just got there myself in a similar way by using an intermediate column H and setting with  =DAY(A1) and then ammending the SUMIF to=IF(H1=H2;"";SUMIF(H$1:H1;H1;B</description><pubDate>Wed, 06 Oct 2010 11:31:06 -0500</pubDate></item><item><title>Forget last post this is the real deal!!!!! Its 3am here and i'm making errorsIve got it sussed the $ sign is okay the problem is the hidden part of the date changing values (the time part) So anew formula Must go in cell C2 and fill down=IF(DAY(A2)=</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469074313#469074313</link><description>Forget last post this is the real deal!!!!! Its 3am here and i'm making errorsIve got it sussed the $ sign is okay the problem is the hidden part of the date changing values (the time part) So anew formula Must go in cell C2 and fill down=IF(DAY(A2)=</description><pubDate>Wed, 06 Oct 2010 11:07:06 -0500</pubDate></item><item><title>Further testing and hair pulling has revealed that is does indeed work as expected if I manaually delete the time portion of the date So it would seem the IF( (DAY(A1)=DAY(A2)  is correctly detecting the change of day and ignoring the time portion bu</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469074105#469074105</link><description>Further testing and hair pulling has revealed that is does indeed work as expected if I manaually delete the time portion of the date So it would seem the IF( (DAY(A1)=DAY(A2)  is correctly detecting the change of day and ignoring the time portion bu</description><pubDate>Wed, 06 Oct 2010 11:04:54 -0500</pubDate></item><item><title>Ive got it sussed the $ sign is okay the problem is the hidden part of the date changing values (the time part) So a new formula Must go in cell C2 and fill down=IF(DATE(A2)=DATE(A3);"";SUMIF(D$2:D2;D2;B$2:B2))Now in Cell D2 this formula ~ you can hi</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469073945#469073945</link><description>Ive got it sussed the $ sign is okay the problem is the hidden part of the date changing values (the time part) So a new formula Must go in cell C2 and fill down=IF(DATE(A2)=DATE(A3);"";SUMIF(D$2:D2;D2;B$2:B2))Now in Cell D2 this formula ~ you can hi</description><pubDate>Wed, 06 Oct 2010 11:03:02 -0500</pubDate></item><item><title>I can see now that it is only SUMming up the last record of the day and the one prior to it. i.e. lines 5 and 6: -27.20 + 29.93 = 2.73lines 10 and 11: 7.91 + -5.83  =  2.08and line 16 doesn't seem to add up with line 15 and is = -9.92 ??so close and</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469068397#469068397</link><description>I can see now that it is only SUMming up the last record of the day and the one prior to it. i.e. lines 5 and 6: -27.20 + 29.93 = 2.73lines 10 and 11: 7.91 + -5.83  =  2.08and line 16 doesn't seem to add up with line 15 and is = -9.92 ??so close and</description><pubDate>Wed, 06 Oct 2010 10:09:27 -0500</pubDate></item><item><title>This is what I'm getting ( with the expected manually generated results in the last column )     A            B    C  Expected Result   1 09/07/10    7.89        2 09/07/10    -3.50        3 09/07/10    -18.40        4 09/07/10    25.46        5 09/0</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469066653#469066653</link><description>This is what I'm getting ( with the expected manually generated results in the last column )     A            B    C  Expected Result   1 09/07/10    7.89        2 09/07/10    -3.50        3 09/07/10    -18.40        4 09/07/10    25.46        5 09/0</description><pubDate>Wed, 06 Oct 2010 09:53:11 -0500</pubDate></item><item><title>I stuffed up again=IF(DAY(A2)=DAY(A3);"";SUMIF(A$2:A2;A2;B$2:B2))</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469064633#469064633</link><description>I stuffed up again=IF(DAY(A2)=DAY(A3);"";SUMIF(A$2:A2;A2;B$2:B2))</description><pubDate>Wed, 06 Oct 2010 09:32:50 -0500</pubDate></item><item><title>I've got =IF(DAY(A2)=DAY(A3);"";SUMIF(A$2:A2;A2;B$2:B2))Which differs from your last formula ( as bolded ) and it's producing totals at the expected place in column 'C' but the actual figures are incorrect. ( i.e. don't tally with the test figures I</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469063861#469063861</link><description>I've got =IF(DAY(A2)=DAY(A3);"";SUMIF(A$2:A2;A2;B$2:B2))Which differs from your last formula ( as bolded ) and it's producing totals at the expected place in column 'C' but the actual figures are incorrect. ( i.e. don't tally with the test figures I</description><pubDate>Wed, 06 Oct 2010 09:24:51 -0500</pubDate></item><item><title>Full of errors todayshould be =IF(DAY(A2)=DAY(A3);"";SUMIF(A:A2;A2;B$2:B2))</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469062225#469062225</link><description>Full of errors todayshould be =IF(DAY(A2)=DAY(A3);"";SUMIF(A:A2;A2;B$2:B2))</description><pubDate>Wed, 06 Oct 2010 09:07:40 -0500</pubDate></item><item><title>Ok getting thereTry =IF(DAY(A2);=DAY(A3);"";SUMIF(A$2:A2;A2;B$2:B2))</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25996917/excel-experts-help?post_id=469062093#469062093</link><description>Ok getting thereTry =IF(DAY(A2);=DAY(A3);"";SUMIF(A$2:A2;A2;B$2:B2))</description><pubDate>Wed, 06 Oct 2010 09:05:57 -0500</pubDate></item></channel></rss>
