Taking data from another worksheet and converting

A

Annerobbo

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
 
A

Annerobbo

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.
 
N

Nadia

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")
 
Top