|
Formula Help PLEASE !!!!
Hello, I have a need for a formula that will do as follows. I have a spread sheet that is filled in every hour with different totals. I need to know how to make what ever total show for the next hour to be put in specified cell. There may be a amount or maybe nothing. Example: Hour 1 I need to know the amount for every hour in D43:k43 with G5 being where the answer needs to go. D43 $100.00 nothing in the rest Total Cell G5 $100.00 Hour 2 D43 $100.00 E43 0 Total Cell G5 0 Hour 3 D43 $100.00 E43 0 F43 $85.00 Total Cell G5 $85.00 Hour 4 D43 $100.00 E43 0 F43 $85.00 G43 $102.00 Total Cell G5 $102.00 Hour 5 D43 $100.00 E43 0 F43 $85.00 G43 $102.00 H43 $15.00 Total Cell G5 $15.00 Hour 6 D43 $100.00 E43 0 F43 $85.00 G43 $102.00 H43 $15.00 I43 $352.00 Total Cell G5 $352.00 and so on for the Final Letters to K43 Can someone Help Thanks flapokey ;) :cool: -- flapokey ------------------------------------------------------------------------ flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690 View this thread: http://www.excelforum.com/showthread...hreadid=400503 |
=INDEX(D43:K43,,MAX(IF(D43:K43<"",COLUMN(D43:K43) ))-COLUMN(D43)+1)
as an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "flapokey" wrote in message ... Hello, I have a need for a formula that will do as follows. I have a spread sheet that is filled in every hour with different totals. I need to know how to make what ever total show for the next hour to be put in specified cell. There may be a amount or maybe nothing. Example: Hour 1 I need to know the amount for every hour in D43:k43 with G5 being where the answer needs to go. D43 $100.00 nothing in the rest Total Cell G5 $100.00 Hour 2 D43 $100.00 E43 0 Total Cell G5 0 Hour 3 D43 $100.00 E43 0 F43 $85.00 Total Cell G5 $85.00 Hour 4 D43 $100.00 E43 0 F43 $85.00 G43 $102.00 Total Cell G5 $102.00 Hour 5 D43 $100.00 E43 0 F43 $85.00 G43 $102.00 H43 $15.00 Total Cell G5 $15.00 Hour 6 D43 $100.00 E43 0 F43 $85.00 G43 $102.00 H43 $15.00 I43 $352.00 Total Cell G5 $352.00 and so on for the Final Letters to K43 Can someone Help Thanks flapokey ;) :cool: -- flapokey ------------------------------------------------------------------------ flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690 View this thread: http://www.excelforum.com/showthread...hreadid=400503 |
Hello, Thank you for your help, but the fomula did not work. I did the CNTRL+SHIFT+ENTER. But nothing flapokey :confused: -- flapokey ------------------------------------------------------------------------ flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690 View this thread: http://www.excelforum.com/showthread...hreadid=400503 |
I have posted an example at http://cjoint.com/confirm.php?cjoint=iFldmrQO4p
which you can play with -- HTH RP (remove nothere from the email address if mailing direct) "flapokey" wrote in message ... Hello, Thank you for your help, but the fomula did not work. I did the CNTRL+SHIFT+ENTER. But nothing flapokey :confused: -- flapokey ------------------------------------------------------------------------ flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690 View this thread: http://www.excelforum.com/showthread...hreadid=400503 |
Thank You I guess I wasn't doing something right before it works fine thank you. flapokey ;) :) -- flapokey ------------------------------------------------------------------------ flapokey's Profile: http://www.excelforum.com/member.php...o&userid=26690 View this thread: http://www.excelforum.com/showthread...hreadid=400503 |
| All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com