Sum formula

Ladkisson
Ladkisson used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Flyster

Commented:
Try this:

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

Flyster
Jeff DarlingDeveloper Analyst

Commented:
How about this?

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

Author

Commented:
this formula does not work
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Learn More!
Jeff DarlingDeveloper Analyst

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

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

Author

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?
Jeff DarlingDeveloper Analyst

Commented:
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),"")
Jeff DarlingDeveloper Analyst

Commented:
sounds good.  sorry for the confusion.
Commented:
@ Ladkisson,

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial