SpreadsheetConverter - IF-formulas cannot return a range
For SpreadsheetConverter v12, see the current help, installation guide or product tour.
Earlier versions: show the original page
IF-formulas cannot return a range.
This is simple to fix, however, you need to edit the formula slightly.
If you have a formula looking like this
=SUMIF(M12:M14,G5,IF(I10="B & W",O12:O14,P12:P14))
make it look like this
=IF(I10="B & W",SUMIF(M12:M14,G5,O12:O14),SUMIF(M12:M14,G5,P12:P14))
So we moved the IF higher, and have two separate calls to SUMIF.
Try this Excel add-in now!
Click on Download to install and test this Excel add-in for Windows.
Click on Upload to let us convert a spreadsheet for you for free.