| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 2 formulas into 1 cell (NEW QUESTION)
Now in a separate cell I need to add those dollar amounts that were the
outcome of my previous formula... example...I need to know the total dollar amount of the cells that had an amount that contained the work "internet"...sorry if confusing didn't know the exact way to word it..... thanks! One way: =SUMPRODUCT(--(A1:A1000="internet"),--(B1:B1000="something else")) In article , Needs help wrote: I need to enter 2 formuals in one cell and I do not know what the formula should be. Example....I need to count the number of cells that contain the word "internet" but only if in another cell it has an amount in it. Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter 2 formulas in 1 cell | Excel Discussion (Misc queries) | |||
| enter 2 formulas into 1 cell | Excel Discussion (Misc queries) | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
![Needs help[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
