Improve company productivity with a Business Account.Sign Up

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

Sum formula

Hi! I need to sum data in column D2:D1649 based on the information in column A1:A1649 that has the word "control". In other words, if column A has "control" then I need to have a total for all the numeric data in column D. Thanks!
0
Ladkisson
Asked:
Ladkisson
  • 4
  • 2
  • 2
1 Solution
 
FlysterCommented:
Try this:

=SUMIF($A1:$A$1649,"*control*",$B$1:$B$1649)

Flyster
0
 
Jeff DarlingDeveloper AnalystCommented:
How about this?

=IF(A1649="control",SUM(D2:D1649),"")
0
 
LadkissonAuthor Commented:
this formula does not work
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Jeff DarlingDeveloper AnalystCommented:
@Flyster - I could not get that formula to work either.  

@ladkisson - I've uploaded a sample that seems to work.
ee-2012122801a.xlsx
0
 
LadkissonAuthor Commented:
@Flyster - I thought I accepted your formula. I said that I had come up with the same answer. Did my acceptance not go through?
0
 
Jeff DarlingDeveloper AnalystCommented:
I was assuming that the cell contains exactly the word "control".

This will sum if the word control is found in cell A1649

=IF(FIND("control",A1649,1),SUM(D2:D1649),"")
0
 
Jeff DarlingDeveloper AnalystCommented:
sounds good.  sorry for the confusion.
0
 
FlysterCommented:
@ Ladkisson,

There has been no acceptance on this question yet. I see others were having problems with my solution. Does it work for you?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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