Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help needed
I need to calculate a year-to-date total from a list of daily production
values. Each day has individual production totals, and it's own daily total, and I need to have the daily totals added up into an annual total elsewhere on the worksheet. I have asked for help on this before, but then no longer needed the spreadsheet and foolishly deleted it without saving the formula I was using to do this with. A mistake I won't be making again, believe me! Any suggestion as to a direction to go here will be helpful! Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help needed
Hi Ben
With dates in A and Values in B with row 1 containing headers, then =SUMPRODUCT(($A2:$A!000<=TODAY())*($B$:$B1000)) Change ranges to suit but make them of equal size. -- Regards Roger Govier "Ben Mehling" wrote in message ... I need to calculate a year-to-date total from a list of daily production values. Each day has individual production totals, and it's own daily total, and I need to have the daily totals added up into an annual total elsewhere on the worksheet. I have asked for help on this before, but then no longer needed the spreadsheet and foolishly deleted it without saving the formula I was using to do this with. A mistake I won't be making again, believe me! Any suggestion as to a direction to go here will be helpful! Thank you! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help needed
Ben I'm not finding it easy to visualize exactly how you have your data organised, but if it's a case of eg in column B you have your individual production totals *and* your daily production totals (ie a summation of the individual production totals) then you have basically doubled up on the values, so one way to get the YTD would be: =SUM(B:B)/2 Obviusly you can adjust the range to suit. Is this what you meant, or have I missed the point? Best regards Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.officehelp.in/member.php?userid=5248 View this thread: http://www.officehelp.in/showthread.php?t=1271098 Posted from - http://www.officehelp.in |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help needed
Small typo
=SUMPRODUCT(($A2:$A1000<=TODAY())*($B$:$B1000)) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Roger Govier" wrote in message ... Hi Ben With dates in A and Values in B with row 1 containing headers, then =SUMPRODUCT(($A2:$A!000<=TODAY())*($B$:$B1000)) Change ranges to suit but make them of equal size. -- Regards Roger Govier "Ben Mehling" wrote in message ... I need to calculate a year-to-date total from a list of daily production values. Each day has individual production totals, and it's own daily total, and I need to have the daily totals added up into an annual total elsewhere on the worksheet. I have asked for help on this before, but then no longer needed the spreadsheet and foolishly deleted it without saving the formula I was using to do this with. A mistake I won't be making again, believe me! Any suggestion as to a direction to go here will be helpful! Thank you! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help needed
I tried it, but got an error. However, a little tinkering got the result I
was looking for. Here's the formula I ended up with: =SUMIF($B7:$B1000, "Total", $C7:$C1000) This is actually much simpler than the one I had before. Thank you for your assistance Roger! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help needed
Hi Ben
As Bob pointed out my formula had a typo, it should have been $B$2:$B$1000. However, that would not have worked, as you have now described the data somewhat differently to that which I had assumed, an column B contains Text. Delighted that you found a solution, and thanks for posting back to let us know. -- Regards Roger Govier "Ben Mehling" wrote in message ... I tried it, but got an error. However, a little tinkering got the result I was looking for. Here's the formula I ended up with: =SUMIF($B7:$B1000, "Total", $C7:$C1000) This is actually much simpler than the one I had before. Thank you for your assistance Roger! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
IF-THEN Formula help needed | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
continuous sum formula needed | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |