Related:
- Condition formatting with four condition
- Available memory less than 15mb condition zero - Guide
- If condition in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel merge cells if condition met ✓ - Excel Forum
- How to clear formatting in excel - Guide
1 response
Hi Prakash,
I arranged your data like this:
This is put in the range A1:F4.
Now you would like to know how many rows/names has:
1. Mar is between 16 and 20
2. Caste is "sc"
3. Student's cat is "girl"
Then use this array formula in any cell:
=SUM(IF(B2:B4>=16,IF(B2:B4<=20,1,0),0)*(E2:E4="sc")*(F2:F4="girl"))
Confirm this formula by hitting Ctrl+Shift+Enter.
Change the range in the array formula to suit your situation.
I hope this is what you want, since your title is different from your query?!
Best regards,
Trowa
I arranged your data like this:
name mar hin eng caste student's cat a 17 15 17 sc girl b 12 18 8 sc girl c 5 10 20 sc boy
This is put in the range A1:F4.
Now you would like to know how many rows/names has:
1. Mar is between 16 and 20
2. Caste is "sc"
3. Student's cat is "girl"
Then use this array formula in any cell:
=SUM(IF(B2:B4>=16,IF(B2:B4<=20,1,0),0)*(E2:E4="sc")*(F2:F4="girl"))
Confirm this formula by hitting Ctrl+Shift+Enter.
Change the range in the array formula to suit your situation.
I hope this is what you want, since your title is different from your query?!
Best regards,
Trowa
