Count Negative and Positive Numbers

Microsoft Excel 2003 (full)
June 21, 2010 at 02:09:06
Specs: Windows XP
 hi, i'm self tought in Excel.I have a row of numbers that are always changing(they're linked to other excel sheets). The numbers are sumtimes negative and sumtimes positive..I'm trying to find out if there's a formula to tell me how many days a number has been negative or positive for??Many thanks in advancePaul

See More: Count Negative and Positive Numbers

#1
June 21, 2010 at 07:11:12
 Do the numbers change more than once a day? If so, should each change be counted?Are you looking to check the numbers in a specific column or in multiple columns? (Details would help.)Will the spreadsheet be opened every day in order to take the count or might it be closed for e.g. 3 days, with those 3 days being assumed to remain either positive or negative, and therefore be counted as 3 days at one or the other.My assumption is that this is going to need a VBA solution and that the date calculations will need to be done based on when the sheet is opened/updated.The more details you can provide about what you are trying to do would help us design a solution.

Report •

#2
June 21, 2010 at 07:16:34
 Hey thanks for your reply, but i just sorted my problem out on another forum i had posted on earlier.Thanks

Report •

#3
June 21, 2010 at 09:16:16
 So, point us to the thread. I'm interested in seeing the solution.

Report •

Related Solutions

#4
June 23, 2010 at 00:46:42
 this is page 3 of the thread:

Report •

#5
June 23, 2010 at 04:07:50
 Thanks.

Report •