SOLVED

Checking multi ranges

Copper 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

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.

best response confirmed by ronniesteel (Copper Contributor)
Solution

@ronniesteel 

See the attached version

@ronniesteel 

 

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

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

@Hans Vogelaar 

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

 

Thanks for your help. 

 

Ronnie

1 best response

Accepted Solutions
best response confirmed by ronniesteel (Copper Contributor)
Solution

@ronniesteel 

See the attached version

View solution in original post