Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Taking data from another worksheet and converting
I need a formula so that if a date is entered in a cell on one worksheet a
cell on another worksheet will add or subtract a 1 to the total that is already there. Thanks |
#2
|
|||
|
|||
Taking data from another worksheet and converting
Sorry I forgot to say that a date in 1 cell would mean an addition and a date
in a different cell would mean a subtraction. "Annerobbo" wrote: I need a formula so that if a date is entered in a cell on one worksheet a cell on another worksheet will add or subtract a 1 to the total that is already there. Thanks |
#3
|
|||
|
|||
Taking data from another worksheet and converting
So you need to count the number of occurrences of positive and negative
values, i.e. #positive values - #negative values ? Assuming that the cell range B8:B100 in your first sheet contains your input range, the following formula would add 1 for each positive value and -1 for each negative amount, 0 for zeros. If you have 40 positive values and 50 negative amounts, the formula would show -10. =COUNTIF(Sheet1!B8:B100,"0")-COUNTIF(Sheet1!B8:B100,"<0") "Annerobbo" wrote: Sorry I forgot to say that a date in 1 cell would mean an addition and a date in a different cell would mean a subtraction. "Annerobbo" wrote: I need a formula so that if a date is entered in a cell on one worksheet a cell on another worksheet will add or subtract a 1 to the total that is already there. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting grid data to side-by-side lists | Excel Discussion (Misc queries) | |||
Converting multiple worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
Converting a muliple page worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |