Solved

Sum formula

Posted on 2012-12-28
8
243 Views
Last Modified: 2012-12-28
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
Comment
Question by:Ladkisson
  • 4
  • 2
  • 2
8 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 38728063
Try this:

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

Flyster
0
 
LVL 12

Expert Comment

by:Jeff Darling
ID: 38728111
How about this?

=IF(A1649="control",SUM(D2:D1649),"")
0
 

Author Comment

by:Ladkisson
ID: 38728123
this formula does not work
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 12

Expert Comment

by:Jeff Darling
ID: 38728132
@Flyster - I could not get that formula to work either.  

@ladkisson - I've uploaded a sample that seems to work.
ee-2012122801a.xlsx
0
 

Author Comment

by:Ladkisson
ID: 38728137
@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
 
LVL 12

Expert Comment

by:Jeff Darling
ID: 38728145
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
 
LVL 12

Expert Comment

by:Jeff Darling
ID: 38728147
sounds good.  sorry for the confusion.
0
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 38728373
@ 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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel VBA 10 39
excel 2016 program to loop through scripts 6 34
Find and Replace Function not working in Excel 13 43
Excel Cell Total 3 20
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

776 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