Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 and IF formulas
Hello all,
In Excel 2007, is there a IF(A2 = BOLD, B2,0)? or =SUMPRODUCT(I17:I1538=BOLD)? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 and IF formulas
No, there isn't. A formula returns a value, not a format.
Pete On Feb 17, 3:28*pm, pgarcia wrote: Hello all, In Excel 2007, is there a IF(A2 = BOLD, B2,0)? or =SUMPRODUCT(I17:I1538=BOLD)? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 and IF formulas
Ok, thanks.
How about counting uniqe items in a list and then sum the cell next to it. I have list with uniqe numbers (meaning, they will not duplicate) and amounts. However, the amounts can be duplicated. How do I sum the amounts? Thanks 000057347 $11,147.60 000057347 $11,147.60 000057347 $11,147.60 000058949 $2,344.09 000058949 $2,344.09 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000800801 $8,088.69 000032525 $2,413.80 000695820 $6,063.28 000695820 $6,063.28 000695820 $6,063.28 000021567 $18,487.22 000001884 $806.93 000001884 $806.93 000099674 $274.00 000001077 $899.94 000001077 $899.94 002283437 $1,403.89 000196237 $304.92 000024561 $4,628.33 000024561 $4,628.33 000024561 $4,628.33 000024561 $4,628.33 000024561 $4,628.33 000025182 $794.49 000025182 $794.49 000036078 $2,053.70 000147042 $22,052.00 000147042 $22,052.00 000147042 $22,052.00 000147042 $22,052.00 000147042 $22,052.00 000023289 $441.96 000256864 $56,873.12 000256864 $56,873.12 000256864 $56,873.12 "Pete_UK" wrote: No, there isn't. A formula returns a value, not a format. Pete On Feb 17, 3:28 pm, pgarcia wrote: Hello all, In Excel 2007, is there a IF(A2 = BOLD, B2,0)? or =SUMPRODUCT(I17:I1538=BOLD)? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 and IF formulas | Excel Discussion (Misc queries) | |||
excel 2007 formulas | Excel Worksheet Functions | |||
Excel 2007 formulas | Excel Discussion (Misc queries) | |||
Formulas in excel 2007 | Excel Discussion (Misc queries) | |||
excel 2007 formulas | Excel Worksheet Functions |