Avatar of Ladkisson
Ladkisson
Flag for United States of America asked on

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

Avatar of undefined
Last Comment
Flyster

8/22/2022 - Mon
Flyster

Try this:

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

Flyster
Jeff Darling

How about this?

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

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

@Flyster - I could not get that formula to work either.  

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

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

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),"")
⚡ 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

sounds good.  sorry for the confusion.
ASKER CERTIFIED SOLUTION
Flyster

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.