You could use SUMPRODUCT like this
=SUMPRODUCT(('data'!A2:A132="dave")*('data'!B2:B132="accept"),'data'!C2:C132/'data'!D2:D132)*100
You could use SUMPRODUCT like this
=SUMPRODUCT(('data'!A2:A132="dave")*('data'!B2:B132="accept"),'data'!C2:C132/'data'!D2:D132)*100
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks