LinkBack URL
About LinkBacks
Dear sir,
I can't use sumifs() condition for multiple options,
Herewith I have attached the excel file please help me with this
Dear sir,
I can't use sumifs() condition for multiple options,
Herewith I have attached the excel file please help me with this
Hi and welcome to the forum
It would help if you provided a few sample answers, however, when using sumifS(), the 1st range is the sum range, not the criteria range - you are using B:B, which contains no numbers.
TYpe in =sumifS( and then click on the Fx to the left ofthe formula bar. It will guide you though what you need
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Dear Mr.Ford
Thanks for the reply
Please check the attachment now
The formula that I entered in the cell H5 in summary sheet is working
But The formula that I used in the cell H6 is not working
I don't know why it is not accepting if I add a second criteria_range & createria
Please go through & Help me for this formula sir
Thank you
Regards
Venkatesh.S
Instead of your formula, try using,Formula:
Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
On sheet3, in H5 try this....
and then drag across and down.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Dear Mr.sktneer
Thank you very much
It is 100% working
But Still small change is needed
That is,
The summary is perfectly coming for the data's that I enter in cell C5 To C16 in CSM report page, but when I enter data in C17 (CSM REPORT) or after that it is not getting added in the summary sheet.
So please revise the formula and update.
The formula is exactly working as what I thought but it should work for all the data that I enter in C column.
Please help
Thanks & regards,
Venkatesh.S
See the attached sheet.
Thank you very much Mr.sktneer
Its working...
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks