Forum Discussion

BCowans's avatar
BCowans
Copper Contributor
Sep 05, 2023

Formula help please

Hello,  I need help with a formula but I'm unsure if it's possible to do so.  It will include a few different tabs.  Tab one, I need the formula to pull the total percentage based off another tab....
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
MVP
Sep 05, 2023

BCowans 

Depends on which Excel version you are, below possibly could work on practically any one. If second range is named answers

here

in C4 it could be

=SUMPRODUCT(
    (INDEX(answers,0,1)=C$2 )*
    (INDEX(answers, 0, MATCH($B4, INDEX(answers,1,0), 0) ) = "Y" ) )
    /
    SUMPRODUCT( 1*(INDEX(answers,0,1)=C$2) )

and drag it to the right and down.

BCowans's avatar
BCowans
Copper Contributor
Sep 05, 2023
I think our versions are different because it didn't convert over. Thank you though!
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 06, 2023

    BCowans 

    If you mean Excel version above formula shall work on practically any one. The only is how your data is structured exactly and how do you name the ranges.

Resources