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!

Ladkisson

Asked: 2012-12-28

Advertise Here

Microsoft Excel

1 Solution

LVL 22

FlysterCommented: 2012-12-28

Try this:

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

Flyster

LVL 13

Jeff DarlingDeveloper AnalystCommented: 2012-12-28

How about this?

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

LadkissonAuthor Commented: 2012-12-28

this formula does not work

LVL 13

Jeff DarlingDeveloper AnalystCommented: 2012-12-28

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

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

LadkissonAuthor Commented: 2012-12-28

@Flyster - I thought I accepted your formula. I said that I had come up with the same answer. Did my acceptance not go through?

LVL 13

Jeff DarlingDeveloper AnalystCommented: 2012-12-28

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