counting the maximum numbers is greater than a particular value

[sadath sheik]

Hi All,

i have a table which contains daily sales by executive wise. i want to count how many times an executive met the target in a week/month??

 

[Somendra Misra]

Hi Sadath Sheikh,

Welcome to the forum.

Please have a look of attached file. Is this what you are looking after?
If not, than please upload a sample file, with input and required output.

Regards,

 

[shrivallabha]

If you use Excel 2007 or later then you can also use:

=COUNTIFS($A$2:$A$15,$H2,$B$2:$B$15,$G2,$C$2:$C$15,">"&$E2)

 

[gns015]

How can I count the non zero cells in a given range of cells, I am uploading a sample worksheet for reference...

 

[Somendra Misra]

Hi gns015,

Welcome to the forum.

As a new user you must read this : http://chandoo.org/forum/threads/new-users-please-read.294/

And regarding your problem use below formula in cell K2 and copy down
=COUNTIF(B2:J2,">0")

Regards,

 

[sadath sheik]

Hi Sadath Sheikh,

Welcome to the forum.

Please have a look of attached file. Is this what you are looking after?
If not, than please upload a sample file, with input and required output.

Regards,

Its not answer to my question. please find the attachment for your reference and find the comment want I mentioned in the attachment.

 

[Somendra Misra]

@sadath sheik

Use in J2 and copy down: =COUNTIF(D2:G2,">1500")

Regards,