“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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