[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 114
  • Last Modified:

excel formula

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
Jagwarman
Asked:
Jagwarman
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=SUMIF(2:2,10)

Regards
0
 
JagwarmanAuthor Commented:
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
Answer = 810

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now