sum with if statement

[turnej]

If I have some columns and I want to work out a percentage but I need an if statement based on a text response in a column how would i go about this?

so basically

if cell a2 = dave and b2 = accept then divide c2/d2*100 and I want this to run on every row in the colum so a2:a132 etc

[TMS]

if cell a2 = dave and b2 = accept then divide c2/d2*100 and I want this to run on every row in the colum so a2:a132 etc

=IF(AND(A2="dave",B2="accept"),C2/D2*100"",)

And copy down to row 132. The cell references will auto-adjust.

Regards

[turnej]

sorry I should have said, the date cells i.e a2 are in a diff worksheet, will it still work?

[turnej]

also I want the answer in one cell so is it possible to using the example before do something like

=IF(AND('data'!A2:a132="dave",'data'!B2:b132="accept"),'data'!C2/'data'!D2*100"",)

I have tried this but it doesn't work

[daddylonglegs]

You could use SUMPRODUCT like this


=SUMPRODUCT(('data'!A2:A132="dave")*('data'!B2:B132="accept"),'data'!C2:C132/'data'!D2:D132)*100