Hi
I've combined a sumifand indirect formula but its only adding figures in one column instead of two
Can anyone correct my formula so that it adds two or more column .
Below is my formula:
=(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!AA:AB"))*Rates!$E$31)+(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!L:V"))*Rates!$E$30)+(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!K:K")))+(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!AC:AD"))*Rates!$E$32)
I ask the formula to sum data from column AA and AB but the formula only sums data in Column AA. Same with L:V and AC:AD.
I've combined a sumifand indirect formula but its only adding figures in one column instead of two
Can anyone correct my formula so that it adds two or more column .
Below is my formula:
=(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!AA:AB"))*Rates!$E$31)+(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!L:V"))*Rates!$E$30)+(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!K:K")))+(SUMIF(INDIRECT("'"&$A3&"'!A:A"),MONTH(W$2),INDIRECT("'"&$A3&"'!AC:AD"))*Rates!$E$32)
I ask the formula to sum data from column AA and AB but the formula only sums data in Column AA. Same with L:V and AC:AD.