How to SUM TWO ARRAY formula results
Thank you both for the suggestions. I may not have been clear enough. The
reason I wanted to use SUM is because I need to add up values from 365 cells.
I've tried =VALUE(C18)+VALUE(C19) but the result is an error #VALUE. Also
tried --RIGHT instead of RIGHT, resulting in an error as well.
Some insight to what I'm trying to do here.
The file tracks employee absence. Employee ID is in cell B1, days in A2
downwards. From Cell B2 down, you can enter "LA 0.5" for example. Indicating
the employee was 0.5 hours LAte. Instead of LA there can be 1 other word
(OTH). In the totals I summarize how many occurence of LA have been found, so
I can see how often this person was late. I also want to know His total
lateness. For this I want to split LA from the 0.5. These must be in one
cell. Splitting the cell (LA in one, 0.5 in another) seems easier but it's
not an option.
NAME HIDDEN COLUMN1 HIDDEN COLUMN2 HIDDEN C3
DAY1 LA 0.5 ARRAY to extract 'value' IF B2=LA*, B2, 0 IF
B2=OTH*,B2,0
DAY2
DAY3
I want to sum hidden column 2 and hidden column 3 somehow. Either by
changing my array formula to return values or some other way.
Hopefully I've explained it clear enough. Thank you for your thoughts on this!
|