Shorter formula

[Skikrazee]

Is there an easier way to write this without getting an error, I have several hunderd of these in my workbook and it is veeerry sloooww?

=IF(ISERROR(SUMIF('Jan Data In'!$B$4:$B$4055,$B8,'Jan Data In'!T$4:T$4055)/COUNTIF('Jan Data In'!$B$4:$B$4055,$B8))," ",SUMIF('Jan Data In'!$B$4:$B$4055,$B8,'Jan Data In'!T$4:T$4055)/COUNTIF('Jan Data In'!$B$4:$B$4055,$B8))


Thanks

Chris

 

[Aladin Akyurek]

Is there an easier way to write this without getting an error, I have several hunderd of these in my workbook and it is veeerry sloooww?

=IF(ISERROR(SUMIF('Jan Data In'!$B$4:$B$4055,$B8,'Jan Data In'!T$4:T$4055)/COUNTIF('Jan Data In'!$B$4:$B$4055,$B8))," ",SUMIF('Jan Data In'!$B$4:$B$4055,$B8,'Jan Data In'!T$4:T$4055)/COUNTIF('Jan Data In'!$B$4:$B$4055,$B8))


Thanks

Chris

=SUMIF('Jan Data In'!$B$4:$B$4055,$B8,'Jan Data In'!T$4:T$4055)/MAX(1,COUNTIF('Jan Data In'!$B$4:$B$4055,$B8))

Custom format the formula cell as:

[=0]"";General

 

[Skikrazee]

Much appreciated Aladin.

One question, how do I limit the decimal to 2 places?

 

[dave3009]

[=0]"";0.00

 

[Skikrazee]

Thank You, Thank You, it works