M
M
maratmd2019-04-08 13:31:17
excel
maratmd, 2019-04-08 13:31:17

How to sum cells with numbers and text in excel?

How to sum cells with numbers and text in excel?
those.
in cell G2, the sum of all cells of row 2 where there is a letter "l" should be obtained,
and in cell H2, the sum of all cells of row 2 where there is a letter "p"
example on the screen
5cab22ed2f557505831457.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-04-08
@maratmd

For the letter "l" the formula is:
For "n" respectively:
Both are array formulas. Entered by simultaneously pressing Ctrl+Shift+Enter

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question