Get instant live expert help on I need help with excel sum of cells with specific text
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula to count or sum cells containing specific text with multiple criteria
Solved by B. E. in 30 mins
help on IF/OR FORMULA, so if a set of parameters is met then the cell will sum to specific cells.
If the parameters are not set then the formula will sum to other specific cells
Solved by B. J. in 23 mins
I need a formula to add text to the cell above specific text. eg: add test above all cells with the word testing
Solved by F. S. in 22 mins
Sum cells based on identical values in another column and place sum in specific spot
Solved by V. U. in 17 mins
Hi, Hopefully someone will be able to help me. I'm wanting to calculate the average sum contained within a range of cells discarding blanks. The problem that I'm encountering is that there is an additional feature where I only want to take into consideration columns that contain specific text.
=SUMIF(G79:HG79,"Sep-18",(G6:HG6/COUNTA(G6:HG6)))
G79:HG79 will contain the specific text with G:HG containing the digits.
Cheers all in advance
Solved by M. J. in 29 mins