MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum Above Formula


Posted by Neil Wiltshire on November 19, 2001 8:50 AM

I know its possible to have a "Sum Above" formula to calculate numbers in an above column, but is there a formula to calculate the number of boxes filled with the letter "X"????


Posted by mike on November 19, 2001 8:57 AM

* * * *

Try using the CountIf function.