zbor and sweep helped me with a formula for counting how many positive and negative number there were on a sheet, (columns B & C). Could someone please explain how I can transfer the values to separate columns. I want to be able to establish an average of the positive and negative values, (columns D & E) http://screencast.com/t/guVkfWSDOm
Hi,
in D2, =IF(A2<0,A2,"")
in E2, =IF(A2>0,A2,"")
copied down.
Average of negative values =AVERAGEIF(A2:A7,"<0")
Average of positive values =AVERAGEIF(A2:A7,">0")
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hi
You can directly get count and average without distributing values in separate columns if you want..
Check attached...
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
thank you guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks