SOLVED

# Checking multi ranges

Occasional Contributor

# Checking multi ranges

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.

Thanks.

5 Replies

# Re: Checking multi ranges

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 (Occasional Contributor)
Solution

# Re: Checking multi ranges

See the attached version

# Re: Checking multi ranges

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

# Re: Checking multi ranges

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

# Re: Checking multi ranges

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