I used to be a whiz on excel formulas but I seem to have had all my prior knowledge drained into my feet.......you are right, I didn't need to use the SUM function at all! I need to spend some time re-learning everything that I have forgotten!

The Archangel

I have to sympathize there. These days I often feel I spend more time relearning old skills than acquiring new ones.

Fortunately, relearning is much easier than starting cold.

Hi all,
I am trying to add up the values in a column in Quick Office Pro. One of the values is a negative number which I don't want to include in the total. In MS Excel I would probably just use SUMIF(A1:A100,>0). This would add up all cells in the range A1 to A100 which are greater than zero. Simple!

However, I can't find the SUMIF function in Quick Office and although it does have various other functions I can't quite work out which one to use. Each function does give you the format for the formula but not a detailed explanation or even some examples. I have tried browsing Quick Office Help but to no avail.

Does anyone know how to add up positive numbers ONLY or find a negative number in order to subtract it from the total?
Any suggestions on how to achieve this or other places to search would be greatly appreciated!

Och Aye the Noob!

I solved my problem by using the IF Function.

My negative number was being generated by subtracting A1 from A2 when A2 had not had a value entered yet. So my formula in B2 was =A2-A1. Where A1 had a value of 125 and A2 was empty the value in B2 was -125.

I used the IF function to check if the value of A2 was empty or equal to zero and if so make B2 equal to zero otherwise carry out the subtraction as normal. So the new formula in B2 is now =IF(A2=0,0,A2-A1).

Now if I use the SUM function in Column B the answer is a positive value!

Simple stuff really but much easier if you can use the SUMIF Function to ignore negative numbers.

Oh Aye the Noob!!!!!