Hi,
I'm looking to carry out a SUMIF Function, however I don't want to use the regular sum_range - I want to add certain individual cells instead. This seems simple but I've not had any joy - it's along the lines of below. I'm using Excel 2007.
=SUMIF(A4:A11,"H",B4+B7+B8+B10) however this sum 'range' part does not work.
Thanks in advance,
Judith
I'm looking to carry out a SUMIF Function, however I don't want to use the regular sum_range - I want to add certain individual cells instead. This seems simple but I've not had any joy - it's along the lines of below. I'm using Excel 2007.
=SUMIF(A4:A11,"H",B4+B7+B8+B10) however this sum 'range' part does not work.
Thanks in advance,
Judith