Sum Cells with Formula ONLY in Excel 🚀 (Excel Formula Trick)

Sum only the cells with a formula in Excel using the SUMPRODUCT function and ISFORMULA.

In this dataset, we have totals that are irregularly spaced and with no common denominator. What they have in common is that they contain a formula.

So, let's sum cells with formula in Excel.

Download the file used in the tutorial

Click the 👍 if you enjoyed the video

🔔 SUBSCRIBE if you’d like more tips and tutorials like this

Learn ALL the important Excel functions

🎥 Related videos

#excel #excelformulas #excelfunctions

[abdallahdataguy]

SUM function can also do the same thing

[LotfiGARZOUN]

If you're unfamiliar with the SUMPRODUCT function, here's a simpler alternative solution using the SUM Excel function:
=SUM(--ESTFORMULE(B3:B17) * B3:B17) 🚀🚀🚀🚀

[MaureenPesch]

This was fantastic! What a great way to reduce risk of errors!!!

[girishpadshala]

Sumproduct function is evergreen, the way you treated is just great. Thanks

[david_allen]

Nice solution. It can also be done using the IF function: SUM(IF(ISFORMULA(B3:B17), B3:B17, 0))

[nadermounir]

Thank you Alan for this interesting video 📹 👍

[razamoulvi]

Nice, We can also use =SUM(FILTER(Amount column, ISFORMULA(Amount column)))

[soniccheese]

Cool trick. I believe if the total is built under the column of values ALT = will sum just the totals.

[derekporter]

any chance of a vid of useful shortcuts around excel? eg . alt + a + c. f4 to repeat all that. thanks

[jerrydellasala]

The tip in this video is using -- before a function that returns true and false, however using SUMPRODUCT could be confusing to others that aren't familiar with the function. While it MIGHT be faster than SUM, the formula produces the same results and possibly less confusing.

[berzaku]

Could we get in touch? I need help with something very specific on Excel and I cant find the answer anywhere 😢

[MooreAvery]

Couldn’t this just be done with the subtotal function?