Sumifs formula in Excel 2007


T

Tigerxxx

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
 
Ad

Advertisements

Ad

Advertisements

A

Abe

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top