Needing an excel formula that has two if/then
Closed
Ginny
-
Oct 12, 2010 at 11:36 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Oct 15, 2010 at 02:40 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Oct 15, 2010 at 02:40 PM
Related:
- Needing an excel formula that has two if/then
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets
2 responses
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Oct 15, 2010 at 12:50 PM
Oct 15, 2010 at 12:50 PM
have a look at this site, it may help in your query /task
https://www.techonthenet.com/excel/formulas/if_nested.php
https://www.techonthenet.com/excel/formulas/if_nested.php
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Oct 15, 2010 at 02:40 PM
Oct 15, 2010 at 02:40 PM
Hi,
1)Corresponding to :=COUNT(IF('Attrition Master'!E2:E56,"Rep")+(IF('Attrition Master'!I2:I56,"October"))) try :
=SUMPRODUCT(('Attrition Master'!E2:E56="Rep")*('Attrition Master'!I2:I56="October"))
2) For the second formula, you have to indicate which Range of cells you want to add if the two conditions are OK
Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
1)Corresponding to :=COUNT(IF('Attrition Master'!E2:E56,"Rep")+(IF('Attrition Master'!I2:I56,"October"))) try :
=SUMPRODUCT(('Attrition Master'!E2:E56="Rep")*('Attrition Master'!I2:I56="October"))
2) For the second formula, you have to indicate which Range of cells you want to add if the two conditions are OK
Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
