| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
First let me say thanks to Rob. This formula works great,
except i need to add all the entries AFTER THIS FORMULA HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF all "john". When i attempt to sum all the entries i am getting an error message. Basically, because i am adding up formula cells. Is there a macro that call sum up all the value of a formula cells. Thanks again ROB AND ANYONE THAT CAN HELP. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
No tsure what you are doing, but have you tried a pivot table?
"mary" wrote in message ... First let me say thanks to Rob. This formula works great, except i need to add all the entries AFTER THIS FORMULA HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF all "john". When i attempt to sum all the entries i am getting an error message. Basically, because i am adding up formula cells. Is there a macro that call sum up all the value of a formula cells. Thanks again ROB AND ANYONE THAT CAN HELP. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
Not exactly sure what you have here, but a "=sumif
(Range,"john",Range), might do the trick. -----Original Message----- First let me say thanks to Rob. This formula works great, except i need to add all the entries AFTER THIS FORMULA HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF all "john". When i attempt to sum all the entries i am getting an error message. Basically, because i am adding up formula cells. Is there a macro that call sum up all the value of a formula cells. Thanks again ROB AND ANYONE THAT CAN HELP. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
There is no problem in summing cells that have formulas in them, but I'll bet
that you are summing them in this manner:- =C1+C2+C3+C4+C5+C6+C7............. This will not work because of the "" being returned by some of the formulas. Change your formula to =SUM(C1:C100) or whatever the ranges are and it will work. You can use Davids reply though, in that you don't actually need your 'helper' column with all your formulas. You can do all that and SUM the results with a single formula in a single cell, eg:- =SUMIF(A1:A100,"John",B1:B100) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "mary" wrote in message ... First let me say thanks to Rob. This formula works great, except i need to add all the entries AFTER THIS FORMULA HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF all "john". When i attempt to sum all the entries i am getting an error message. Basically, because i am adding up formula cells. Is there a macro that call sum up all the value of a formula cells. Thanks again ROB AND ANYONE THAT CAN HELP. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
I am using the =SUM(C1:C100)
-----Original Message----- There is no problem in summing cells that have formulas in them, but I'll bet that you are summing them in this manner:- =C1+C2+C3+C4+C5+C6+C7............. This will not work because of the "" being returned by some of the formulas. Change your formula to =SUM(C1:C100) or whatever the ranges are and it will work. You can use Davids reply though, in that you don't actually need your 'helper' column with all your formulas. You can do all that and SUM the results with a single formula in a single cell, eg:- =SUMIF(A1:A100,"John",B1:B100) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 --------------------------------------------------------- ------------------- It's easier to beg forgiveness than ask permission :-) --------------------------------------------------------- ------------------- "mary" wrote in message ... First let me say thanks to Rob. This formula works great, except i need to add all the entries AFTER THIS FORMULA HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF all "john". When i attempt to sum all the entries i am getting an error message. Basically, because i am adding up formula cells. Is there a macro that call sum up all the value of a formula cells. Thanks again ROB AND ANYONE THAT CAN HELP. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004 . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
Do you have any cells in that range with an error in them, eg #VALUE, #N/A, #NUM
etc Feel free to mail me a copy of the workbook, or even a copy of just that range if you prefer and I'll happily take a quick look. You would need to take the NOSPAM bit out of my email address. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "mary" wrote in message ... I am using the =SUM(C1:C100) -----Original Message----- There is no problem in summing cells that have formulas in them, but I'll bet that you are summing them in this manner:- =C1+C2+C3+C4+C5+C6+C7............. This will not work because of the "" being returned by some of the formulas. Change your formula to =SUM(C1:C100) or whatever the ranges are and it will work. You can use Davids reply though, in that you don't actually need your 'helper' column with all your formulas. You can do all that and SUM the results with a single formula in a single cell, eg:- =SUMIF(A1:A100,"John",B1:B100) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 --------------------------------------------------------- ------------------- It's easier to beg forgiveness than ask permission :-) --------------------------------------------------------- ------------------- "mary" wrote in message ... First let me say thanks to Rob. This formula works great, except i need to add all the entries AFTER THIS FORMULA HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF all "john". When i attempt to sum all the entries i am getting an error message. Basically, because i am adding up formula cells. Is there a macro that call sum up all the value of a formula cells. Thanks again ROB AND ANYONE THAT CAN HELP. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004 . --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.562 / Virus Database: 354 - Release Date: 16/01/2004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| How do I change "Doe, John" to "John Doe" in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
