Log In
Register
Home
July 8, 2021
Offline
Hello,
I need a formula to calculate my answer including the file
Thank you in advance for your response
See Answer
Trusted Members
February 13, 2021
Offline
I used the Sumproduct function to get the answer you are looking for. See the attached file, hope it helps! 🙂
July 8, 2021
Offline
Thank you for your time
But it's so difficult once I have thousands variable data
Counting positive and negative numbers simply is just a hint
Your formula does not perform calculations automatically
Regards
Trusted Members
February 13, 2021
Offline
I'm confused as to what you are looking for, then? You don't want the average of the positives and the average of the negatives? What are you looking to achieve?
July 8, 2021
Offline
I want average of positive and negative number in column A and also it's need to calculate automatically column B because I have variable data in thousands numbers and column B can be changed everyday and it is impossible to resync manualy column B
first formula be able to count consecutive number in column B and then through that calculate average count
Please delete column B and count it in formula "automatic count column B"
I apologize for the complexity of my question
Thank you in advance
July 8, 2021
Offline
Please look at column B & C in this file
it can be calculate automated but the result is not true
look at please and I'm sure you get my mean
Thank you very much
Trusted Members
Moderators
November 1, 2018
Offline
Using helper columns:
In b2: =IF(A2>=0,IF(OR(A3<0,A3=""),COUNTIF(A$2:A2,">=0")-SUM(B$1:B1),""),"")
and copy down.
In C2: =IF(A2<0,IF(OR(A3>=0,A3=""),COUNTIF(A$2:A2,"<0")-SUM(C$1:C1),""),"")
and copy down. Then just use AVERAGE on each of those columns.
Answers Post
1 Guest(s)
