I need a formula that will search worksheet 1 row 1 for an ID matching worksheet 2 row 1 and return the sum of all data when worksheet 1 col A matches a set character.
Basically I need a sum if that will search for 2 specific criteria in two specific areas.
Example attached.
This is the formula I have in it now, returning a #Value error.
=SUM(IF(WTB!S12:JQ12, B2, IF(WTB!I14:I133, "A105",WTB!S14:JE135)))
B2 being the ID I need it to search for, "A105" is the identifier I need it to sum.
These are some of the samples of formulas I am using in other areas of this project.
=IFERROR(VLOOKUP($B14,INDIRECT("'"&SUBSTITUTE(VLOOKUP(BT$12,Master!$A$1:$D$999,2,FALSE),"'","''")&" "&BT$12&"'!$A:$D"),4,FALSE),"")
=SUMIF($L$12:$ZY$12, $A$2, L78:ZY78)
=INDEX('PS&R Data'!$C$2:$ZZ$213, MATCH(D11, 'PS&R Data'!$B2:$B$163, 0), MATCH(E2, 'PS&R Data'!$C$2:$ZZ$2, 0))
The only one I thought might work is the INDEX but I don't have an unique identifier for each of the 150 clients data.
My guess (and hope) this one won't be so complicated and I am just WAY over-thinking it!!
Any help would be appreciated!
Thanks
Bookmarks