Forum Discussion

jai7820's avatar
jai7820
Copper Contributor
Jul 07, 2020

How to auto populate 1 cell from a range of cells if it matches a specific text

HI all,

 

I am attempting to auto populate a cell, from a range when specific text is found

 

however i cannot get it to work, i am a novice at excel and am completely stuck 

 

=SUMIF('EDGE Data'!P2:P5000,"OH", 'EDGE Data'!AB2:AB5000)=AND('EDGE Data'!V2:V5000,"01",'EDGE Data'!AB2:AB5000, E36)

 

so if the range hits a match for OH and 01 it will add the figures that match that criteria and place into cell E36 but i keep getting this #VALUE

 

I forgot to mention the figures that need adding are in cells AB2:AB5000

 

can anyone help please??

 

thank you in advance for your help

excel

1 Reply

  • TheAntony's avatar
    TheAntony
    Iron Contributor
    Jul 07, 2020

    jai7820 , try this:

    =SUMIFS('Edge Data'!$AB$2:$AB$5000, 'Edge Data'!$P$2:$P$5000,"OH",'Edge Data'!$V$2:$V$5000,"01")

Resources