| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
I am having a problem writing a formula to calculate the information I need in report. Is it possible to write a formula that will automatically fill in the pink table based on the information contained in the 3 columns? I manually plugged the numbers in the pink cells but am wondering if there is a way to automate this. Thank you for any help. Steve +-------------------------------------------------------------------+ |Filename: Formula.pdf | |Download: http://www.excelforum.com/attachment.php?postid=4737 | +-------------------------------------------------------------------+ -- hipkey ------------------------------------------------------------------------ hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245 View this thread: http://www.excelforum.com/showthread...hreadid=539962 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
link says invalid attachment
"hipkey" wrote: I am having a problem writing a formula to calculate the information I need in report. Is it possible to write a formula that will automatically fill in the pink table based on the information contained in the 3 columns? I manually plugged the numbers in the pink cells but am wondering if there is a way to automate this. Thank you for any help. Steve +-------------------------------------------------------------------+ |Filename: Formula.pdf | |Download: http://www.excelforum.com/attachment.php?postid=4737 | +-------------------------------------------------------------------+ -- hipkey ------------------------------------------------------------------------ hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245 View this thread: http://www.excelforum.com/showthread...hreadid=539962 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
I get an 'invalid attachement' message when I tried to look at what you are
referring to (thus we have no idea the significance of the pink area.) "hipkey" wrote: I am having a problem writing a formula to calculate the information I need in report. Is it possible to write a formula that will automatically fill in the pink table based on the information contained in the 3 columns? I manually plugged the numbers in the pink cells but am wondering if there is a way to automate this. Thank you for any help. Steve +-------------------------------------------------------------------+ |Filename: Formula.pdf | |Download: http://www.excelforum.com/attachment.php?postid=4737 | +-------------------------------------------------------------------+ -- hipkey ------------------------------------------------------------------------ hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245 View this thread: http://www.excelforum.com/showthread...hreadid=539962 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Try following the link for * View this thread: * and then using the link in
excelforum -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Tim M" wrote in message ... I get an 'invalid attachement' message when I tried to look at what you are referring to (thus we have no idea the significance of the pink area.) "hipkey" wrote: I am having a problem writing a formula to calculate the information I need in report. Is it possible to write a formula that will automatically fill in the pink table based on the information contained in the 3 columns? I manually plugged the numbers in the pink cells but am wondering if there is a way to automate this. Thank you for any help. Steve +-------------------------------------------------------------------+ |Filename: Formula.pdf | |Download: http://www.excelforum.com/attachment.php?postid=4737 | +-------------------------------------------------------------------+ -- hipkey ------------------------------------------------------------------------ hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245 View this thread: http://www.excelforum.com/showthread...hreadid=539962 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
I am having a problem writing a formula to calculate the information I need in report. Is it possible to write a formula that will automatically fill in the pink table based on the information contained in the 3 columns? I manually plugged the numbers in the pink cells but am wondering if there is a way to automate this. Thank you for any help. Steve +-------------------------------------------------------------------+ |Filename: Excel.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4738 | +-------------------------------------------------------------------+ -- hipkey ------------------------------------------------------------------------ hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245 View this thread: http://www.excelforum.com/showthread...hreadid=539962 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Reconstructing you initial data table in A1:C6 (you don't have any cell
references in your attachment) and the Results table in D9: J11 with the Projects in D9:D11 $0 - $49.99 # formula: =SUMPRODUCT(($C$2:$C$60)*($C$2:$C$6<50)*($B$2:$B$ 6=D10)) Total formula: =SUMPRODUCT(($C$2:$C$60)*($C$2:$C$6<50)*($B$2:$B$ 6=D10)*($C$2:$C$6)) $50 - $99.99 Formula: =SUMPRODUCT(($C$2:$C$6=50)*($C$2:$C$6<100)*($B$2: $B$6=D10)) Total formula: =SUMPRODUCT(($C$2:$C$6=50)*($C$2:$C$6<100)*($B$2: $B$6=D10)*($C$2:$C$6)) $100 formula: =SUMPRODUCT(($C$2:$C$6=100)*($B$2:$B$6=D10)) Total formula: =SUMPRODUCT(($B$2:$B$6=D10)*($C$2:$C$6=100)*($C$2 :$C$6)) and cop down for Project ITB -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "hipkey" wrote in message ... I am having a problem writing a formula to calculate the information I need in report. Is it possible to write a formula that will automatically fill in the pink table based on the information contained in the 3 columns? I manually plugged the numbers in the pink cells but am wondering if there is a way to automate this. Thank you for any help. Steve +-------------------------------------------------------------------+ |Filename: Excel.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4738 | +-------------------------------------------------------------------+ -- hipkey ------------------------------------------------------------------------ hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245 View this thread: http://www.excelforum.com/showthread...hreadid=539962 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
