# help with average if another cell contains date

#### roussery

##### New Member
I need help with a formula please:
I need to average cells if others contains date
ex: b4 , f4, g4 has date, then I need to average b5,f5,g5.
b5,f5,g5 contains percentages. if there is no date it contains 0 and I do not need to include if there is no date.

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### AliGW

##### Banned
Which version of Excel do you have?

=AVERAGEIF(B4:G4,<>0,B5:G5)

#### roussery

##### New Member
excel 2010 and I screwed that up!

I need to average cells if others contains date
ex: b4 , f4, o4 has date, then I need to average c4,g4,p4.
c4,g4,p4 contains percentages. if there is no date it contains 0 and I do not need to include if there is no date.
one column may or may not contain a date,the next column contains a percent. I only need to average the columns with percent if the prior column contains a date

#### AliGW

##### Banned
Try this, then (untested):

=AVERAGEIF(B4:O4,<>0,C4:P5)

#### roussery

##### New Member
kicking out error

#### AliGW

##### Banned
And the error is ... ?

#### roussery

##### New Member
total change of plan.
need to average if prior cell contains a #, not a date. same theory. b4, g4 o4 have a number, then I need to average c4, h4, p4

#### AliGW

##### Banned
What is the error message you are getting? Let's sort that out first, as it may be relevant to your new scenario.

We really need to see a representative sample of your data.

Last edited:

error is B4:O4

#### AliGW

##### Banned
That's not an error message. What is the error message? Please provide us with some properly representative sample data to work with.

Replies
2
Views
64
Replies
8
Views
175
Replies
4
Views
72
Replies
7
Views
167
Replies
3
Views
148

1,191,517
Messages
5,987,059
Members
440,074
Latest member
Emmanuelian

### 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