wintermute
New Member
Hi guys,
could you help me with one formula which can fulfill gray area on a picture below:
https://docs.google.com/document/d/1sPgiI1RNXcv7TEnkzD_We-IsVZRHta-FWPqwXAs6kOA/edit?pli=1
I have to consolidate data with layout as picture shows, in orange area.
No problem to sumif with manually changed range for criteria, but I'm looking for solution that can fill whole gray area with just one function.
Thanks in advance
could you help me with one formula which can fulfill gray area on a picture below:
https://docs.google.com/document/d/1sPgiI1RNXcv7TEnkzD_We-IsVZRHta-FWPqwXAs6kOA/edit?pli=1
I have to consolidate data with layout as picture shows, in orange area.
No problem to sumif with manually changed range for criteria, but I'm looking for solution that can fill whole gray area with just one function.
Thanks in advance