Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing a formula
I need a formula for the following:
Lets say on "sheet 2" I need C16 to = C14+C15 off of "sheet 1" but it would also need to = C23+C24+25+C26+C27+C28+C29 off of "sheet 1". If they do not = each other then I would need a red flag, pop up error, or something to let me know. Any help would be greatly appreciated. Also if I did not post this question in the correct area please let me know. Thanks! jjwho |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing a formula
Firstly, yes, this is a good area to post such a query,
Try, =IF(SUM(Sheet1!C14:C15)=SUM(Sheet1!C23:C29),TRUE,F ALSE) This will give you TRUE or FALSE if the condition is met or not. You can then use Conditional Formatting to flag the cell red if you want to, a pop up is a little more complicated as you need to use VB code to do that, Regards, Alan. "jjwho" wrote in message ... I need a formula for the following: Lets say on "sheet 2" I need C16 to = C14+C15 off of "sheet 1" but it would also need to = C23+C24+25+C26+C27+C28+C29 off of "sheet 1". If they do not = each other then I would need a red flag, pop up error, or something to let me know. Any help would be greatly appreciated. Also if I did not post this question in the correct area please let me know. Thanks! jjwho |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
NEEDING FORMULA Please | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |