Hi
Need help on Count if formula which I have input in G2 of the attached excel.
Don't have any Idea why this formula is not working if anyone can help it will be a great help
Attached file:- Countif formula.xlsx
Regards
Arindam
Hi
Need help on Count if formula which I have input in G2 of the attached excel.
Don't have any Idea why this formula is not working if anyone can help it will be a great help
Attached file:- Countif formula.xlsx
Regards
Arindam
Seems like you want SUMIF vs. COUNTIF
Ben Van Johnson
In The attached sheet's G2 I wanted to calculate
in the range A: A how many times the name "Ankit.raj" is appearing where it has some data in B:B.
I am looking for this formula.
You want COUNTIFS, not COUNTIF:
=COUNTIFS(A:A,"Ankit.raj",B:B,"<>")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks its working
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks