Formula help
Closed
rgreen
Posts
1
Registration date
Tuesday October 29, 2013
Status
Member
Last seen
October 29, 2013
-
Oct 29, 2013 at 10:28 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 29, 2013 at 01:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 29, 2013 at 01:00 PM
Related:
- Formula help
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 29, 2013 at 01:00 PM
Oct 29, 2013 at 01:00 PM
Hi RGreen,
Do this experiment to understand array formula's:
A1: 5
A2: 5
A3: 5
B1: F
B2: empty
B3: F
Question: Add column A if column B = "F"
Answer: 10
Array formula: =SUM(IF(B1:B3="F",1,0)*A1:A3)
NOTE: Array formula's need to be confirmed by hitting Ctrl+Shift+Enter. If done correctly the formula will be enclosed by curly brackets.
Best regards,
Trowa
Do this experiment to understand array formula's:
A1: 5
A2: 5
A3: 5
B1: F
B2: empty
B3: F
Question: Add column A if column B = "F"
Answer: 10
Array formula: =SUM(IF(B1:B3="F",1,0)*A1:A3)
NOTE: Array formula's need to be confirmed by hitting Ctrl+Shift+Enter. If done correctly the formula will be enclosed by curly brackets.
Best regards,
Trowa
