satish gubbi
09-10-2015, 05:59 AM
Hi Team,
I have workbook with two tabs Analysis and Data tab.
Data tab will have details
I would require “=SUMIFS” formula which would pull details based on the Cell B1 and B2, C2 & D2 for respective Names in column A
Ideally, if I change the Month (Cell B1), it should pick the details for particular month from the Data tab.
Kindly help me in this regard
Regards,
Satish Gubbi
I have workbook with two tabs Analysis and Data tab.
Data tab will have details
I would require “=SUMIFS” formula which would pull details based on the Cell B1 and B2, C2 & D2 for respective Names in column A
Ideally, if I change the Month (Cell B1), it should pick the details for particular month from the Data tab.
Kindly help me in this regard
Regards,
Satish Gubbi