SUMIF Problems

[Markus]

Hi Can some one help me im having some trouble with it. It does not allow me
to say greater or smaller as cell A117 =SUMIF(A7:A114;<A117;C7:C114) does
anybody have an idea on what im doing wrong

Markus

 

[Ron Rosenfeld]

Hi Can some one help me im having some trouble with it. It does not allow me
to say greater or smaller as cell A117 =SUMIF(A7:A114;<A117;C7:C114) does
anybody have an idea on what im doing wrong

Markus

You need to put the operator in quote marks, and concatenate the cell
reference.

From HELP for that function:

Important Any text criteria or any criteria that includes logical or
mathematical symbols must be enclosed in double quotation marks ("). If the
criteria is numeric, double quotation marks are not required.


e.g.:

=SUMIF(A7:A114;"<"&A117;C7:C114)

--ron

 

[Markus]

Thank you

You need to put the operator in quote marks, and concatenate the cell
reference.

From HELP for that function:

Important Any text criteria or any criteria that includes logical or
mathematical symbols must be enclosed in double quotation marks ("). If the
criteria is numeric, double quotation marks are not required.


e.g.:

=SUMIF(A7:A114;"<"&A117;C7:C114)

--ron