Related:
- Excel - if then statements
- How many nested if statements in excel - Guide
- If then statements in excel - Guide
- Excel marksheet - Guide
- Excel apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
1 response
Hi Straderade,
If you want to add up a column of numbers depending an a value in another column it's wise to use an array formula.
I randomly put "+" and "-" in range A1:A20, then I put random numbers in range D1:D20.
To add up the numbers in column D only if range A1:A20 shows a "+" for that row, use the following formula:
=SUM((A1:A21="+")*(D1:D21))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
Does this solve your query?
Best regards,
Trowa
If you want to add up a column of numbers depending an a value in another column it's wise to use an array formula.
I randomly put "+" and "-" in range A1:A20, then I put random numbers in range D1:D20.
To add up the numbers in column D only if range A1:A20 shows a "+" for that row, use the following formula:
=SUM((A1:A21="+")*(D1:D21))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter.
Does this solve your query?
Best regards,
Trowa