I have an array of cells. Each column has a corresponding numerical value. Within each row, a cell may contain text. I need to sum up the corresponding values for each row from the numbers pertaining to each column if the corresponding cell contains any text.
Given column values in B1:G1, in A2 and below use the formula =SUMIF(B2:G2;"*";B$1:G$1).
EDIT: Choose menu Tools - Options… - LibreOffice Calc - Calculate, and check Enable wildcards in formulas.
See LibreOffice Help on SUMIF
See sample file.
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).
For some reason, "*" isn’t working on my sheet. I’m certain I’ve followed these steps, however.
This is the exact formula I have in cell BK4: =SUMIF(D4:BJ4,"*",D$2:BJ$2) The value, however, remains at 0 when it should be 10 (1+1+4+4).
Just added a second paragraph to the answer.
I’m afraid “Enable wildcards in formulas” is already enabled.
Values in B1:G1 (as in the sample file), are numbers or numbers as text?
Press Ctrl+F8: if values are blue they are numbers; if black, are text. Tell us (press Ctrl+F8 again to revert to normal colors). If they are numbers, click edit below your question and use the paper clip to upload a sample file (remove all sensible data before).
Alternatively: Select the four cells, and look at the status bar (just to the left of the zoom bar): it they are numbers must show Sum: 10.
Regards.