Advance Excel || 8) COUNTIF Function in MS Excel || Example-1.
Name | State | Sales in (Rs.) |
Adrian | Gujarat | 5000 |
Nathan | Goa | 2500 |
John | Kerala | 1250 |
Gerard | Haryana | 1875 |
Zacharias | Delhi | 9872 |
John | Tamil Nadu | 7800 |
Fexlix | Gujarat | 18700 |
Isaac | Gujarat | 458 |
Kane | Punjab | 22400 |
Example | Results |
Sales over Rs. 4500 | ? |
Sales below Rs. 4500 | ? |
Sales by John | ? |
Sales in Gujarat | ? |
Comments
Post a Comment