Hi

Try
=""&A1

--
Regards
Roger Govier

"Tigerxxx" wrote in message
...
Hi,

In Excel 2007, under the sumifs formula, how can I set up a condition
rfeerencing a cell.
Example: "A1".
The sumifs formula does not seem to take the reference to a cell.

Thank you