# (solved)Need help with formulat :IF(condition),Average(if...

#### zeriab

##### New Member
Hi All,

Trying to calculate the AgeAvg of pending order for specific planner (cellsA5). the result given is #N/A.

Pls help

=IF(C5>0,AVERAGE(IF('#'!\$BE\$2:\$BE\$3179="Pending",IF('#'!\$M\$2:\$M\$3112=A5,'#'!\$BC\$2:\$BC\$3179))),"--")

Regards

Zeriab

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Hi Zeriab

In an array formula all arrays must have the same size, or else at some point there are values not available (#N/A).

In your case 2 of the arrays go from row 2 to row 3179, and the third goes from row 2 to row 3112. This is not possible.

for example:

=IF(C5>0,AVERAGE(IF('#'!\$BE\$2:\$BE\$3179="Pending",IF('#'!\$M\$2:\$M\$3179=A5,'#'!\$BC\$2:\$BC\$3179))),"--")

Hope this helps
PGC

Replies
3
Views
177
Replies
2
Views
170
Replies
5
Views
373
Replies
5
Views
233
Replies
1
Views
127

1,221,200
Messages
6,158,491
Members
451,497
Latest member
Marese

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back