Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Dev_1518

Copper Contributor

Aug 17, 2022

TO COUNT A CELL WITHOUTH USING COUNTIF

So i have an issue where i have been told to count the number of cell based on a certain criteria in this case i have to calculate the number of people working in sales dept i have two columns N...

excel

Formulas and Functions

HansVogelaar

MVP

Aug 17, 2022

Dev_1518

=SUM(IF(B2:B6="Sales",1,0))

If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.

Dev_1518
Copper Contributor
Aug 18, 2022
HansVogelaar Sorry but your formula isint yielding the correct answer 😞
- HansVogelaar
  MVP
  Aug 18, 2022
  Dev_1518
  
  Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
  - Dev_1518
    Copper Contributor
    Aug 18, 2022
    @HansVogelaar
    https://docs.google.com/spreadsheets/d/1PnbUq9nKv8jLcDJmqO52Be1i70WSTUWFYYoVmot1wvI/edit?usp=sharing
- Harun24HR
  Bronze Contributor
  Aug 18, 2022
  This =SUM(IF(B2:B6="Sales",1,0)) should give you correct result. Check you data either have leading or trailing space. Also this should work =SUM(--(B2:B6="Sales")).