About
Pricing
Community
Teams
Start Free Trial
Log in
Ladkisson
asked on
12/28/2012
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!
Microsoft Excel
8
1
Last Comment
Flyster
8/22/2022 - Mon
Flyster
12/28/2012
Try this:
=SUMIF($A1:$A$1649,"*contr
ol*",$B$1:
$B$1649)
Flyster
Jeff Darling
12/28/2012
How about this?
=IF(A1649="control",SUM(D2
:D1649),""
)
Ladkisson
12/28/2012
ASKER
this formula does not work
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Jeff Darling
12/28/2012
@Flyster - I could not get that formula to work either.
@ladkisson - I've uploaded a sample that seems to work.
ee-2012122801a.xlsx
Ladkisson
12/28/2012
ASKER
@Flyster - I thought I accepted your formula. I said that I had come up with the same answer. Did my acceptance not go through?
Jeff Darling
12/28/2012
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:D
1649),"")
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Jeff Darling
12/28/2012
sounds good. sorry for the confusion.
ASKER CERTIFIED SOLUTION
Flyster
12/28/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
=SUMIF($A1:$A$1649,"*contr
Flyster