Tried this myself using the Function Wizard and noticed that it does NOT work
when I type =""&A1 in the Criteria box. I tried typing ""&A1 and this time
it worked.

Thanks Roger.

"Tigerxxx" wrote:

Wonderful....it worked!
Thanks a bunch!

"Roger Govier" wrote:

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