Hi everyone, please suggest me the solution of this worksheet.
I want, in column C cells that contains C8/10 and if in column A contains .05.2013 than sum the corresponding value from column B.
I want to recognize cells in column A by partly text.
For example attached a worksheet that contains a table with the values that i need to obtain.
Thanks in advance.
Book11.xlsx
Try this SUMIFS..
Formula:
Please Login or Register to view this content.
Thank GOD, you Date are not actual Date..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Copy the formula in Cell G6 of your attached sheet, and drag and fill the rest of the table.
Deep
Please Login or Register to view this content.
Last edited by NeedForExcel; 07-18-2013 at 05:29 AM.
Cheers!
Deep Dave
Work perfect !
I want to put the table in sheet 2.
If i don't ask to much can you write me the same formula but take values from sheet 1.
Thank you a lot.
Select a Range of cells (Any Range) but the current table you want to copy should be inside the range. Cut it (Using Ctrl+V) and Paste it on sheet2.
Deep
Last edited by NeedForExcel; 07-18-2013 at 08:07 AM.
It work.
Thank you
Sure!
Cheers!
Deep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks