View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
veryeavy veryeavy is offline
external usenet poster
 
Posts: 72
Default 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