Hi all,
I have a sumproduct formula
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'HTML Code:SUMPRODUCT((X7:X80="In progress, but not in forecasts")*AQ7:AT80)
does anyone have any ideas?
Many thanks,
Nick