Cell values as criteria for SUMIF and other functions

W

Will

Hi,

I have just changed jobs and am now working on XP instead of office
2000. I used to be able to write a formula such as:

=SUMIF(A2:A10,<D2,B2:B10)

I can't seem to be able to reference a cell for a criterion when the
operator is anything other than "=". Can somebody point me in the
right direction.

Thanks & Regards,

Will
 
L

Leo Heuser

Will said:
Hi,

I have just changed jobs and am now working on XP instead of office
2000. I used to be able to write a formula such as:

=SUMIF(A2:A10,<D2,B2:B10)

I can't seem to be able to reference a cell for a criterion when the
operator is anything other than "=". Can somebody point me in the
right direction.

Thanks & Regards,

Will
Click to expand...

Hi Will

The correct syntax is:

=SUMIF(A2:A10,"<"&D2,B2:B10)
 

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

Quick SUMIF() query - criteria relating to cell 2
sumif when criteria range is larger but includes criteria 1
Criteria Syntax in SUMIF formula 10
Averageifs - criteria is cell is not blank 1
SUMPRODUCT Criteria Via Cell Reference?? 8
Using a SUMIF and Parsing to sum part of a cell 6
can lookup return cell reference istead of "text" for sumif? 4
Criteria Syntax in SUMIF formula 4

Top