Hello,
I have one daily chart which I am filling by myself according to the data that I recieve. But now I have to create a summary table for this. This summary should be categorized according to the dates. The data which I write down on the daily table, should go the summary table for the same date in the same time. If I add new dates, summary table should recognize it and must fill the empty cells on that day. An example is attached. I need help about that.
Thanks in advance.
Last edited by oozden; 09-27-2014 at 07:49 AM. Reason: Solved
In H2 copied down
=SUMIF($C$2:$C$9, G2,$B$2:$B$9)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi, Try this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
thx for your answers. they worked for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks