SUMIF Problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Markus - 17 Apr 2008 10:22 GMT

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

Reply to this Message

Ron Rosenfeld - 17 Apr 2008 12:29 GMT

>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

Reply to this Message

Markus - 18 Apr 2008 06:12 GMT

Thank you

> >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
[quoted text clipped - 16 lines]
>
> --ron

Reply to this Message