nicko
09-02-2008, 07:22 AM
Hi all,
I have a sumproduct formula
SUMPRODUCT((X7:X80="In progress, but not in forecasts")*AQ7:AT80)
and I want to add a sumif formula so the sumproduct only adds cells when the word "Direct" is entered in a cell in the respective row in column 'G'
does anyone have any ideas?
Many thanks,
Nick
I have a sumproduct formula
SUMPRODUCT((X7:X80="In progress, but not in forecasts")*AQ7:AT80)
and I want to add a sumif formula so the sumproduct only adds cells when the word "Direct" is entered in a cell in the respective row in column 'G'
does anyone have any ideas?
Many thanks,
Nick