Nov 15 2020 04:32 AM
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.
Nov 15 2020 05:02 AM
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.
Nov 15 2020 05:11 AM
SolutionSee the attached version
Nov 15 2020 05:11 AM
Nov 15 2020 05:21 AM
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
Nov 15 2020 05:30 AM
Nov 15 2020 05:11 AM
Solution