Good day,
How could I find all values at once via one multi-cell array formula (one for all cells)?
I can simply enter non-array formula smth like this one:and find all values one by one, but can't do the same with all selected cells.HTML Code:
Good day,
How could I find all values at once via one multi-cell array formula (one for all cells)?
I can simply enter non-array formula smth like this one:and find all values one by one, but can't do the same with all selected cells.HTML Code:
Last edited by T.I.; 01-23-2021 at 03:34 PM.
Please try
=SUMIFS(B2:F6,A2:E6,I2:I5)
or
=SUMIFS(B2:F6,A2:E6,I2)
So simple... I should have guessed!
Thank you so much, Bo_Ry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks