Count and Sum Function

O

omi

Hi,

Here is a set of data. Can Someone show me how make
excell calcualte the differnce between these rows and
count at the same time.

Coulumn A
58.63
58.27 -0.36
58.66 0.39
59.21 0.55
59.73 0.52
59.57 -0.16
59.43 -0.14

Desired End result: There are 3 values >0 and their sum is
1.46. ( My preference is to do this without using Coumn B)

Thx
 
B

Bob Phillips

.... any advances <vbg>

Bob

Ken Wright said:
See response in newusers

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

-------------------------------------------------------------------------- --
Attitude - A little thing that makes a BIG difference
-------------------------------------------------------------------------- --
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM AND COUNT 3
Statistics 1
Count function 4
Count and Sum function 2
Count and Sum Functions based on multiple column criteria 1

Top