I am working on a spreadsheet that calculates the monthly price based on the number of active support criteria. Normally I would use a standard SUMIF function, however the column it uses for the sum range needs to be variable based on a criteria (month).
A B C D
Jan-09 Feb-09
Server1 Basic 1 0
Server2 High 1 1
Server3 Basic 0 1
So normally I would use SUMIF(B:B,"Basic",C:C), but now I need it to have the C:C variable based on on the month.
A B C D
Jan-09 Feb-09
Server1 Basic 1 0
Server2 High 1 1
Server3 Basic 0 1
So normally I would use SUMIF(B:B,"Basic",C:C), but now I need it to have the C:C variable based on on the month.