Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing A Row Header Containing a Slash
What is the correct syntax for referencing a row header than contains a slash
(e.g. B/S) in a formula? FWIW: This is a formula which is part of the criteria for a DSUM. And Yes! I think it is related to the slashes as it works fine when I remove them from the header and the formula. TIA and Regards to the group from this very occasional visitor :) Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing A Row Header Containing a Slash
What is the correct syntax for referencing a row header than contains a
slash (e.g. B/S) in a formula? FWIW: This is a formula which is part of the criteria for a DSUM. And Yes! I think it is related to the slashes as it works fine when I remove them from the header and the formula. I may not have made this as clear as I could have ... .... this is where the row header is a means of referencing all the data in the column, specifically: There is a column called "B/S" with the range "Mydata" that is referenced by the formula: =DSUM(Mydata,"Amt",G27:G28) where I have a calculated criteria in Cell G28, namely: =(B/S="B") and "B/S" is the header of one of the columns in the range "Mydata". If I remove the slash from the formula and from the row header it works fine. Cheers, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slash marks in dates | Excel Discussion (Misc queries) | |||
How do I make a zero appear with a slash | Excel Discussion (Misc queries) | |||
Header and cell referencing | Excel Discussion (Misc queries) | |||
Zero with a slash | Excel Discussion (Misc queries) | |||
How can I put a slash in a zero in Office 97 | New Users to Excel |