Dear awesome viewers! Thank you for your amazing engagement! Remember, the most liked comment gets pinned - so start liking your favorites now! I love your questions and will try to respond to as many as I can. For quick generic queries, the comment section is perfect. But need more in-depth, personalized advice? Book a personalized consultations with me via topmate.io/mehran_vahedi. They're ideal for detailed, specific questions. Your support means the world to me. Let's keep the conversation going! Thank You!

Thanks ,once again I will try ,then I will ping my comment..but you're awesome .I hope this video will help me.

Useful video. Thanks

@realmehranvahedi

Жыл бұрын

Hi Fatemeh, many thanks for the comment. I'm glad you liked it. Make sure you turn on notification as I have a lot of new cool videos coming up in the upcoming weekes.

Hi. The video was amazing and it sorted my half of the problem, But I need to give two date ranges stating from 01-Jul-2023 to 31-01-2023.

@realmehranvahedi

4 ай бұрын

Hello! Thank you for reaching out with your comment. From what you've described, it sounds like incorporating an end date criteria into the formula will address your needs. The good news is that the solution is straightforward. Simply extend the existing formula by adding an additional argument. This argument should include a criteria range along with the new criteria you wish to apply. For instance, you can append the following to the formula I previously explained: ,$C$3:$C$18,"

It worked....

@realmehranvahedi

Жыл бұрын

I'm happy to hear that. Glad you found it useful. If you want me to create videos on any other topics please share them in the comments section. I am all ears and will be happy to create more videos on topics which you are interested in.

Im trying to do a SUMIFS with 2 Vlookup but I can't make it right

@realmehranvahedi

Жыл бұрын

Hi Nelson, thanks for comment. When you try what happens?

i tried it but its showing zero as the result pls help out

@realmehranvahedi

Жыл бұрын

Thanks for the comment. What is the result you are expecting. Have you used the same formula as explained in the video or have you modified it? Have you ensured that data types are consistent where you are doing a VLOOKUP?