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
 
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

Similar Threads

Worksheet name as a variable in VBA 1
Looking to added up based on a character from cell range 1
Sumifs in Excel 2007 for only numerical values 15
Convert SUMIFS formula from 2007 to 2003 5
sumifs problem 2
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 3
Sumifs 9
SUMIFS formula, reading text 1

Top