Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Can you please help me with this problem; I have 2 Columns, with 5 Rows each
or any amount of rows, for example Column A contains the following numbers 3, ,4, ,2 and column B Contains 1,2,3,4,5. What I want to do is Compare both columns and if the rows contain any numbers (rows 1,3 and 5 in this example), I want the column A numbers to be added so in this example since row number 1,3 and 5 match, I want them added which in this case would equal 9. Thanks in advance. Hiran |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Perhaps you could try:
=SUMPRODUCT(--(ISNUMBER(B1:B5)), A1:A5) "HIRAN" wrote: Can you please help me with this problem; I have 2 Columns, with 5 Rows each or any amount of rows, for example Column A contains the following numbers 3, ,4, ,2 and column B Contains 1,2,3,4,5. What I want to do is Compare both columns and if the rows contain any numbers (rows 1,3 and 5 in this example), I want the column A numbers to be added so in this example since row number 1,3 and 5 match, I want them added which in this case would equal 9. Thanks in advance. Hiran |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
If the values in column A are unique (or if you want to count each
instance of the number in column A), one way: =SUMPRODUCT(--(COUNTIF(B1:B100,A1:A100)0),A1:A100) In article , HIRAN wrote: Can you please help me with this problem; I have 2 Columns, with 5 Rows each or any amount of rows, for example Column A contains the following numbers 3, ,4, ,2 and column B Contains 1,2,3,4,5. What I want to do is Compare both columns and if the rows contain any numbers (rows 1,3 and 5 in this example), I want the column A numbers to be added so in this example since row number 1,3 and 5 match, I want them added which in this case would equal 9. Thanks in advance. Hiran |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |