Forum Discussion
Solved
Combining ISFORMULA and INDEX to Add Non-Formula Values Based on Column Header
I'm attempting to combine ISFORMULA and INDEX in a SUM formula and for some reason am hitting a wall. =SUM(INDEX('Invoices to be Paid'!A1:ZZ7000,,MATCH("Amount",'Invoices to be Paid'!1:1,0))) ^T...
Does this do what you want?
=SUMPRODUCT('Invoices to be Paid'!A2:ZZ7000,('Invoices to be Paid'!A1:ZZ1="Amount")*NOT(ISFORMULA('Invoices to be Paid'!A2:ZZ7000)))
It spits out "TRUE" but no number value, I'm afraid
Weird. It works for me - I have tested it again.
Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.
- That's bizarre... I moved it into a new workbook per your request and it worked, so I retried it in the original and then it worked there as well (literally no changes- copy & pasted a second time). No idea what went wrong the first time through, but thanks so much for the assistance!
