SOLVED

Checking multi ranges

%3CLINGO-SUB%20id%3D%22lingo-sub-1888110%22%20slang%3D%22en-US%22%3EChecking%20multi%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888110%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20this%20formula%20works%20fine%22%3DSUMIF(Medal!E18%3AAV18%2C%22DF%22%2CMedal!E21%3AAV21)%22%20but%20I%20now%20want%20to%20also%20include%20E19%3AAV19%20and%20E20%3AAV20%20ranges%20for%20evaluation.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20changing%20to%26nbsp%3B%3DSUMIF(Medal!E18%3AAV20%2C%22DF%22%2CMedal!E21%3AAV21)%26nbsp%3Bbut%20no%20joy.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1888110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1888154%22%20slang%3D%22en-US%22%3ERe%3A%20Checking%20multi%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888154%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711099%22%20target%3D%22_blank%22%3E%40ronniesteel%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20explain%20your%20query%20in%20detail%2C%20can%20you%20please%20let%20me%20know%20where%20you%20are%20applying%20the%20SUMIF%20function%20along%20with%20that%20also%20please%20let%20us%20know%20what%20your%20desired%20result%20is%3F%20I%20have%20checked%20the%20sheet%20unfortunately%20unable%20find%20SUMIF%20formula%20on%20your%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1888174%22%20slang%3D%22en-US%22%3ERe%3A%20Checking%20multi%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711099%22%20target%3D%22_blank%22%3E%40ronniesteel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1888176%22%20slang%3D%22en-US%22%3ERe%3A%20Checking%20multi%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F711099%22%20target%3D%22_blank%22%3E%40ronniesteel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDitto%20to%20what%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%20just%20said.%20WHERE%20is%20that%20formula%20that%20you%20say%20%22works%22%3F%3F!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi, this formula works fine"=SUMIF(Medal!E18:AV18,"DF",Medal!E21:AV21)" but I now want to also include E19:AV19 and E20:AV20 ranges for evaluation. 

I tried changing to =SUMIF(Medal!E18:AV20,"DF",Medal!E21:AV21) but no joy. 

Please help. 

Thanks. 

5 Replies
Highlighted

Hi @ronniesteel,

 

Can you please explain your query in detail, can you please let me know where you are applying the SUMIF function along with that also please let us know what your desired result is? I have checked the sheet unfortunately unable find SUMIF formula on your workbook.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Highlighted
Best Response confirmed by ronniesteel (Occasional Contributor)
Solution

@ronniesteel 

See the attached version

Highlighted

@ronniesteel 

 

Ditto to what @Faraz Shaikh  just said. WHERE is that formula that you say "works"??!!

Highlighted

Hi,@Faraz Shaikh

 Thanks for your reply.

I'm applying the sumif in the money sheet N4 through to N11. 

I'm trying to count the winning 2's money on the medal sheet. E21 to AV21

Hope this helps

Ronnie

Highlighted

@Hans Vogelaar 

Hi, That's the result I was looking for.

 

Thanks for your help. 

 

Ronnie