Marcster
01-17-2006, 06:09 AM
Hello people :hi:,
I want to change the following formula:
=SUMIF('Sheet1'!C:I,"DEMO",'Sheet1'!I:I)
It sums all amounts in column I for "DEMO"
I want it changing so it sums all amounts
in column I for "DEMO" and "0 - 30 Days"
and not just "DEMO".
DEMO is in column C. 0 - 30 Days is in column G
I've tried putting an AND in but doesn't work:
=SUMIF('Sheet1'!C:I,AND("DEMO","0 - 30 Days),'Sheet1'!I:I)
Or is there another formula or a UDF I can use?. :think:
Thanks,
Marcster.
I want to change the following formula:
=SUMIF('Sheet1'!C:I,"DEMO",'Sheet1'!I:I)
It sums all amounts in column I for "DEMO"
I want it changing so it sums all amounts
in column I for "DEMO" and "0 - 30 Days"
and not just "DEMO".
DEMO is in column C. 0 - 30 Days is in column G
I've tried putting an AND in but doesn't work:
=SUMIF('Sheet1'!C:I,AND("DEMO","0 - 30 Days),'Sheet1'!I:I)
Or is there another formula or a UDF I can use?. :think:
Thanks,
Marcster.