PDA

View Full Version : Solved: how do i merge two formulas



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

Bob Phillips
09-02-2008, 08:42 AM
SUMPRODUCT((X7:X80="In progress, but not in forecasts")*(G7:G80="Direct)*(AQ7:AT80))

nicko
09-02-2008, 12:41 PM
brilliant, this is working.

many thanks,