excel formula

Posted on 2014-08-15
Last Modified: 2014-08-15
is there a formula that will find all amounts across a row and add them up.

i.e. lets say I have 10.00 in cells B2,G2, K2, M2, AA2, AK2

I need a formula that will find all of these and total them.

Possible ?

Question by:Jagwarman
    LVL 47

    Accepted Solution


    pls try



    Author Comment

    Hi Rgonzo1971, maybe I didn't explain it too well.

    =SUMIF(2:2,10) is returning 0


    the amounts could be any amount + or minus so they could be  B2=10,G2=100, K2=1000, M2=-500, AA2=250, AK2=-50
    Answer = 810


    Author Comment

    Rgonzo forget my last post it is me being stupid. Once again thanks for your help.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    excel formula or VBA 7 36
    Formula to count names row by row 2 35
    Search multiple lines 3 26
    Excel list clean up 6 22
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now