In B6 cell
Formula:=COUNTIFS(Data!$A:$A,$I$2,Data!$B:$B,B$5)
Drag it to right
In B7 cell
Formula:=SUMIFS(Data!$C:$C,Data!$A:$A,$I$2,Data!$B:$B,B$5)
Drag it to right
Hope that helps!
In B6 cell
Formula:=COUNTIFS(Data!$A:$A,$I$2,Data!$B:$B,B$5)
Drag it to right
In B7 cell
Formula:=SUMIFS(Data!$C:$C,Data!$A:$A,$I$2,Data!$B:$B,B$5)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks