Excel- auto formula

Copper Contributor

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??

AlexEanbu_0-1723872167667.png

 

 

Thank you

 

 

2 Replies
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.

@AlexEanbu 

If you're looking to count the cells with images that can be done if the images are placed in the cell.

Patrick2788_0-1723894218859.png

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.