Touble with SUMIF

[Gazzzz]

Hi ALL!
I am having a little trouble trying to retrive a number on th
condition that another cell is greater than 0. My function I am tryin
to write looks something like this: =SUMIF(N4,">0",P7+1)

So if the cell N4 is greater than 0 I would like the cell P7+
inserted. But i seem to be getting a function error all the time.
hope someone can shed some light on this.

Gazzz

 

[Frank Kabel]

Hi
use the IF statement:
=IF(N4>0,P7+1,"")

 

[Gazzzz]

Hi again!
I tried =IF(N4>0,P7+1,"") but I still get an error telling me th
function I wrote contains an error. I am using Excel 2003 if that ma
help

Regards

Gazzz

 

[Frank Kabel]

Hi
do you use a localized, non english Excel version?. If not what error
did you get (exact description)

 

[Mark Graesser]

Hi Gazz
What type of error are you getting? Also, what cell are you entering the formula in

Regards
Mark Graesse
(e-mail address removed)
Boston M

----- Gazzzz > wrote: ----

Hi again
I tried =IF(N4>0,P7+1,"") but I still get an error telling me th
function I wrote contains an error. I am using Excel 2003 if that ma
help

Regard

Gazzz

 

[Gazzzz]

Hello again!
I have fixed the problem, I must use semi-colons instead for commas.
have encountered another problem. I would like to now drag this formul
down the column for about 300 or more rows. The problem now is I wan
the P7 to stay the same, while I do want the N4 to change to N5, whic
it does, but unfortunately P7 changes to P8. IS there a workaround,
keyboard combination or must I change it all by hand.

THanks again

 

[Frank Kabel]

Hi
that's a simple one:
=IF(N4>0,$P$7+1,"")
or for your delimiter
=IF(N4>0;$P$7+1;"")

you may have a look at absolute/relative references in Excel's help

 

[Guest]

The SUMIF function is for a range of cells that it
evaluates for a specific criteria in order to sum the
amounts from another column. Sounds like you may want an
IF/THEN statement:

IF(N4>0,P7+1,0)

The commas represent the word "Then" so it reads:

If N4 is greater than 0 then P7+1 else 0.

 

[Guest]

Put a $ in front of the 7 to make it absolute.