| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enter 2 formulas into 1 cell
I need to create 1 formula in cell f94 that adds my cells but it has to meet
2 criteria. example...I need my formula to count the cells in f2:f86 only if it says "internet" and only if it contains a number in cells m2:m86. Please help! thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
enter 2 formulas into 1 cell
=SUMPRODUCT(--(F2:F86="internet"),--(M2:M86<0))
-- Gary''s Student - gsnu200752 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
enter 2 formulas into 1 cell
=SUMPRODUCT(--(F2:F86="internet"),--(ISNUMBER(M2:M86)))
"Needs help" wrote: I need to create 1 formula in cell f94 that adds my cells but it has to meet 2 criteria. example...I need my formula to count the cells in f2:f86 only if it says "internet" and only if it contains a number in cells m2:m86. Please help! thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 turn ON auto REcalculate for formulas if new data enter? | Excel Worksheet Functions | |||
| enter data into multiple formulas at once | Excel Worksheet Functions | |||
| how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
Linear Mode
