Solved

excel formula

Posted on 2014-08-15
88 Views
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 ?

Thanks
0
Question by:Jagwarman

LVL 47

Accepted Solution

Hi,

pls try

=SUMIF(2:2,10)

Regards
0

Author Comment

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

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

but

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

Thanks
0

Author Comment

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

Featured Post

Suggested Solutions

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.