|
[VIEWED 5482
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
syanjali
Please log in to subscribe to syanjali's postings.
Posted on 08-18-08 12:01
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
| $100 |
|
| $200 |
|
| $300 |
|
| $50 |
|
| $1 |
|
| $25 |
|
Total 675 6
Hi, I need a formula that will count 1 transaction for each. Sometimes I have more lines. I need a fourmula that will count 1 for each transaction and total numbers of tranaction occured. I had done long time ago, could not figure out.
If a1>.01=1 then a1<.01=0
Thanks
|
| |
|
|
|
|
parbatya
Please log in to subscribe to parbatya's postings.
Posted on 08-18-08 12:08
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Use the COUNT formula and it can omit blank cells too.
|
| |
|
|
Sharp
.JPG)
Please log in to subscribe to Sharp's postings.
Posted on 08-18-08 12:26
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Syanjali, huna ta ma Tanahu ko hu, tara just 10 mins from syangja Boarder, use the countif function
=COUNTIF(A1:A7,">.01")
i had my data range in cell A1 thru A7 and >.01 was the minimum criteria to count,
Hope it will be helpful to you. BTW donot forget to use quotation marks
|
| |
