G
Guest
In the following formaula i am essentually summing a range if another range
in the same row = zero
=IF(SUM(CT2:CW2)=0,SUM(CW2
H2),0)
My worksheet fill this down to row 300 and I total this at the the top,
however I am not really after the detail of each row but ratherjust the total
as I am going to roll the formula and the detail will add too many columns to
my sheet.
How do I modify the above as an array formula so that it inspect and total
for rows 2 to 300.
I have this but its does not work;
{=IF(SUM(CT2:CW300)=0,SUM(CW2
H300),0)}
Bruce
in the same row = zero
=IF(SUM(CT2:CW2)=0,SUM(CW2
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
My worksheet fill this down to row 300 and I total this at the the top,
however I am not really after the detail of each row but ratherjust the total
as I am going to roll the formula and the detail will add too many columns to
my sheet.
How do I modify the above as an array formula so that it inspect and total
for rows 2 to 300.
I have this but its does not work;
{=IF(SUM(CT2:CW300)=0,SUM(CW2
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
Bruce