SUMIF Problems

  • Thread starter Thread starter Markus
  • Start date Start date
M

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
 
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
Click to expand...

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

Ron Rosenfeld said:
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
Click to expand...
 
Back
Top