Sheet 3 raw data
2000 rows just enough data for to see if it computes
Sheet1 stock summming according to query highlighted yellow
thus formula on b2 to drag down , d2 to drag down and so on
Sheet2 stock summing horizontal flow , formula on c2 to drag down and right
Formula at row infinity as I am expected to paste more data
If the formula works for the vertical table flow it should plug the following quantities into the following date
for stock code 100.000.16 and the rest of the dates of february as zero
Please Login or Register to view this content.
The answer of sheet 1 is tougher than Sheet2 thus if answer can go in parts by person
Deleted reply Post not of interest to OP.
Last edited by DBY; 05-16-2015 at 01:28 PM.
Hi there. If you want SUMIDFS, this will do it on sheet 2:
=SUMIFS(Sheet3!$D:$D,Sheet3!$B:$B,Sheet1!$A$1,Sheet3!$A:$A,Sheet1!A2)
and for sheet 2
=SUMIFS(Sheet3!$D:$D,Sheet3!$B:$B,Sheet2!$A2,Sheet3!$A:$A,Sheet2!C$1)
Last edited by Glenn Kennedy; 05-16-2015 at 01:34 PM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Wow Glenn
ha ha ha
Working
Anyone for answer sheet2 , sheet 1 I am done
Sheet 1 is more interest for me as I see more data at one glance but for one code
Makinmomb... What is missing from my suggestion for Sheet2?
Just noticed that I said sheet 3 at Post number 6, now amended to Sheet 2....
Thanks glenn , double decker chicken eaten , i thought you would eat one
thank you again
Lol!! Thanks for the feedback!! "See" you again some other time...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks