G
Guest
Hi there,
I need your help to solve sumproduct formule for the Area column :
Target Status Date
=== ===============================
jan,feb(march 06) done 1 mar 06
March 06 done 20 feb 06
dec 05,jan,feb,march(april 06) done 1 apr 06
feb 06 cancel 28 feb 06
feb (March 06) ongoing 15 march 06
feb 06 done 7 feb 06
I want to sum all target grouped in "Feb" which has been "done".
=SUMPRODUCT((D49="*feb*")*(E4:E15="done"))
the result is : 0 ( i assumed that the sumproduct can not identify *
(asterisk) as i tought --> * = any charachter)
the correct one should be : 3
Please help me to solve this problem. I have number of column and hundreds
row needed to be sum with multiple condition of formula such above formula
(summing wihtin 2 condition)
Thank you
Firman
Ericsson Indonesia
I need your help to solve sumproduct formule for the Area column :
Target Status Date
=== ===============================
jan,feb(march 06) done 1 mar 06
March 06 done 20 feb 06
dec 05,jan,feb,march(april 06) done 1 apr 06
feb 06 cancel 28 feb 06
feb (March 06) ongoing 15 march 06
feb 06 done 7 feb 06
I want to sum all target grouped in "Feb" which has been "done".
=SUMPRODUCT((D49="*feb*")*(E4:E15="done"))
the result is : 0 ( i assumed that the sumproduct can not identify *
(asterisk) as i tought --> * = any charachter)
the correct one should be : 3
Please help me to solve this problem. I have number of column and hundreds
row needed to be sum with multiple condition of formula such above formula
(summing wihtin 2 condition)
Thank you
Firman
Ericsson Indonesia