Hi All,
I would like to understand how to go about trying 2 criteria for this formula
1. The first example would be in column A, i want to count the number of times apple appears but not counting the word pear and lemon in column c
2. The second example would be if apple appears in column A, to count the just number of times the word pear appears in column c
Please Login or Register to view this content.
Can you provide some sample data and what the expected outcome is?
Hi,
I have added a file to better explain the sum.I have added in a 3rd example to help me understand how do i amend formulas with multiple criteria.
Try these:
Excel 2016 (Windows) 32 bit
Sheet: Sheet1
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.
Thank you very much guys.
Last edited by michael35; 06-16-2019 at 07:52 AM.
A pleasure!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks