Hi all, I have hit the brick wall when trying to build up a table in a way that values are taken from the source table based on multiple criteria.
Thanks in advance
Hi all, I have hit the brick wall when trying to build up a table in a way that values are taken from the source table based on multiple criteria.
Thanks in advance
Maybe in B6 and copy to the right.
=COUNTIFS(Data!$A$2:$A$6,Table!$I$2,Data!$B$2:$B$6,Table!B$5)
In B7 and copy to the right.
=SUMIFS(Data!$C$2:$C$6,Data!$A$2:$A$6,Table!$I$2,Data!$B$2:$B$6,Table!B$5)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
In B6 cell
Formula:Please Login or Register to view this content.
Drag it to right
In B7 cell
Formula:Please Login or Register to view this content.
Drag it to right
Hope that helps!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks that solved it. Got tangled up myself somehow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks