|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 30th, 2005, 02:54 AM
|
|||
|
|||
|
Excell Help
This forum is the closest i can find for Excell help, so apologies if slightly off topic.
If i have a number of columns, one column containing a finacial value, the other containing sales peoples initials, and i need to count how many times a sales person has an account with a value greater than zero. What formula do i need to use? Many thanks and kindest reagrds Howard
|
|
#2
June 1st, 2005, 07:12 AM
|
|||
|
|||
|
Hi Howard,
I think you need to use the "IF" command. Highlight the required Cell, Row or Column and then go to the Insert menu and choose #function. Then choose All and look for IF in the right hand menu. From there it is a case of trial and error but this should be quite straight forward. cheers Elliott
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Excell Help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
