Ladkisson
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!
How about this?
=IF(A1649="control",SUM(D2 :D1649),"" )
=IF(A1649="control",SUM(D2
ASKER
this formula does not work
@Flyster - I could not get that formula to work either.
@ladkisson - I've uploaded a sample that seems to work.
ee-2012122801a.xlsx
@ladkisson - I've uploaded a sample that seems to work.
ee-2012122801a.xlsx
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?
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),"")
This will sum if the word control is found in cell A1649
=IF(FIND("control",A1649,1
sounds good. sorry for the confusion.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=SUMIF($A1:$A$1649,"*contr
Flyster