Solved: how do i merge two formulas

[nicko]

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

[Bob Phillips]

SUMPRODUCT((X7:X80="In progress, but not in forecasts")*(G7:G80="Direct)*(AQ7:AT80))

[nicko]

brilliant, this is working.

many thanks,