Forum Discussion
Excel- auto formula
Hii,
Is it possible auto formula in excel, i want to sum 20 rows with the image i entered same formula, or any other formula or options??
Thank you
2 Replies
If you're looking to count the cells with images that can be done if the images are placed in the cell.
When a picture is placed in the cell, Excel puts the alt text in the cell and shows the picture at the sheet level. Pictures with no alt text will store "Picture" in the cell.
- Unfortunately, Excel cannot directly apply formulas to images. Images are treated as static objects within the spreadsheet, and Excel doesn't have the capability to extract numerical data from images and perform calculations on them. If you can provide more details about the image format, the type of data it contains, and the frequency of this task, I might be able to offer more specific recommendations.
