Touble with SUMIF

  • Thread starter Thread starter Gazzzz
  • Start date Start date
G

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
 
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
 
Hi
do you use a localized, non english Excel version?. If not what error
did you get (exact description)
 
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
 
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
 
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
 
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.
 
How to stop cells changing when you copy formulae

If you name a cell as a range, it stays put when you drag the formula. Click on the cell or cells, then in the top left-hand where it lists the cell names, type a range-name. Then, in your formula, use the range name.
 
Back
Top