Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter 2 formulas in 1 cell
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter 2 formulas in 1 cell
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter 2 formulas in 1 cell
Hi,
You aren't very specific when you say another cell has an amount in so this assumes an amount is anything 0 but that condition could equaly be <"" <0 Or many others. =SUMPRODUCT((A1:A20="Internet")*(B1:B200)) Mike "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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter 2 formulas in 1 cell
One way is to try sumproduct, something like this in say, C1:
=sumproduct((a1:a10="internet")*(b1:b10<"")) Adapt the ranges to suit a1:a10 is where the text "internet" would appear, while b1:b10 would contain the amounts, if any -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Needs help" wrote: I need to enter 2 formulas 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter 2 formulas in 1 cell
THANK YOU SO MUCH! IT WORKED !!
After working on it for 6 hours yesterday!! "Mike H" wrote: Hi, You aren't very specific when you say another cell has an amount in so this assumes an amount is anything 0 but that condition could equaly be <"" <0 Or many others. =SUMPRODUCT((A1:A20="Internet")*(B1:B200)) Mike "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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with another formula
Can you please help me with my next step...in addition to my previous email,
now in another cell I need to add up the totals of the amounts in the cells only that only contained the word "internet" ..Thanks! "Needs help" wrote: THANK YOU SO MUCH! IT WORKED !! After working on it for 6 hours yesterday!! "Mike H" wrote: Hi, You aren't very specific when you say another cell has an amount in so this assumes an amount is anything 0 but that condition could equaly be <"" <0 Or many others. =SUMPRODUCT((A1:A20="Internet")*(B1:B200)) Mike "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! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with another formula
"Needs help" wrote:
.. need to add up the totals of the amounts in the cells only that only contained the word "internet" ..Thanks! Assuming B1:B20 contain the amounts to be summed, with A1:A20 housing text such as "internet" If you're still talking multi-conditions, then use eg: =SUMPRODUCT((A1:A20="Internet")*(B1:B20=100),B1:B 20) which will sum only the amounts =100 in col B where col A contains: internet If it's only for a single condition, use SUMIF, eg: =SUMIF(A1:A20,"internet",B1:B20) Think SUMIF will suffice for you here -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
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) |