I was looking for this to count samples with different status (A,P,C,U,I,X) and different arrival months and I was not satisfied with adding 5 countifs formula. Thank you for that explanation
If need count other than completed and have lot of conditions like planning, pendinig,inprogress, like more than 5. Can you suggest me how can I use the formula. Finally the result should be total of all the conditions expect completed.
What if I wanted to use criteria as a reference of the cell rather than "Completed" or "Pending"? I mean cell F5, F6 & F7. Further, If you further explain, how to use criteria as a reference of the cell in a table.
The combination of SUM and COUNTIFS really saves me a lot of time and energy. I appreciate it.
The perfect explanation in a short time. I didn't know to add the SUM function. Thank you.
Most welcome
Excellent tutorial. Concise with clear explanation. Two thumbs up.
Glad you enjoyed it!
I was looking for this to count samples with different status (A,P,C,U,I,X) and different arrival months and I was not satisfied with adding 5 countifs formula. Thank you for that explanation
Thanks a lot
Really Helpful and Time Saving
I was stuck forever trying to figure this out thank you
You're most welcome
I was looking for this exact thing. Thank you for explaining so well.
Most welcome
Most welcome
Thank you, this was perfect!
Thank you sir.
Very informative video.
Welcome
Thank you very much sir 😊😊😊
So nice of you
Nice topic friends thanks for sharing. Please make video for updating schedule every week that would be great. Thanks in advance
Thanks a lot for the feedback.
I welcome you to subscribe to this channel to enjoy more interesting videos.
@@dptutorials i already subscribe my friend
Thank alot
hi i need or condition in Sum ifs formula
is that possible pls explain
thank you very mutch
Well done
thanks a lot
Wonderful
Thank you! Cheers!
Nice bro 😎 this really helps me
Glad to hear that
If need count other than completed and have lot of conditions like planning, pendinig,inprogress, like more than 5. Can you suggest me how can I use the formula. Finally the result should be total of all the conditions expect completed.
Yes, like explained in this video, you can give multiple conditions using the { ,""}.
What if I wanted to use criteria as a reference of the cell rather than "Completed" or "Pending"? I mean cell F5, F6 & F7. Further, If you further explain, how to use criteria as a reference of the cell in a table.
Hello. If I needed to use the column "State" as a criteria as well, how would it look like?
Hi, just add the 2nd criteria as usual
Will this work in google sheets also?
Not exactly
Sir, suppose we have two column and then we want more than one criteria in each column than what formula we should use....
Hi, You can use the same logic like mentioned in the video.
Thanks
Welcome
Or logic formula is not working in google sheet. if i'm looking for sum of 2 result this formula is working in google sheet please help
Let me explore please
Can you please make a similar video on Google sheets
Surely will try.
Can you please let me know how will it work in Google sheets, little urgent
How can I count absent or leave of a employee that he plan suddenly after and before his rest day
Please mail me the excel sheet. So that I can help you with a solution.
"Complete or in progress" formula doesn't work in Google sheets. Please help
Yes, will check for some solution.
This is not working on google sheets
please provide the same in spreadsheet
Sure, will add the link in the description.
nice. please share the file
Surely, i am adding the link in the description for your reference please.
Sir y r u use not very easy function SUMPRODUCT
SUMPRODUCT is always best 😊