Good day. I am trying to create a sumproduct formula that uses 2 criteria to determine value.
Example: In Form A, formula (highlighted in green) in E9 is =SUMPRODUCT('IS YTD'!B92:CZ2000*('IS YTD'!A92:A2000=C9)*('IS YTD'!B90:CZ90=E5)) where
B92:CZ2000 is data range
A92:A2000 is list of organizations (row criteria)
B90:CZ90 is Account Names (column criteria)
C9 is "Revenue" located in C9
E9 is "China Total" located in E5
For the life of me, I can't get this darn formula to not give me a #VALUE! I think it might have something to do with the formatting on the other sheet that comes out of Oracle. My brain would love some help.
Bookmarks