Hi guys,
I was wondering if you can help me with my formula
I can't seem to pinpoint the mistake/error or perhaps in general regarding my formula.
Can someone take a look at my spreadsheet.
My goal is to basically, pull/extract data from another sheet to another sheet but it has to be meet criteria's
=SUMPRODUCT(('3'!$C$2:$C$208=$B6)*('3'!$B$2:$B$208=E$4)*(TEXT('3'!$A$2:$A$208,"mmmm")=$D$3)) <--- I think this is wrong completely
Eitherway,
$B6 is the building name
$D$3 is the month (which I can change that affects results of the month I want to see)
I'm trying to get data from the amount of doors sold in each month when I create a table from sheet 3 but it has to follow each criteria due to amount of doors being sold in each building along with the month
I have attached a work sample. I would be grateful if someone can help me out but also explain if possible
I have tried using VLOOKUP for example =VLOOKUP(SheetnameColumn,TABLENAME,1,FALSE) but this only works when you have 1 month of data and when requiring to change month, It does not work
Bookmarks