Forum home » Delegate support and help forum » Microsoft Excel Training and help » AVERAGEIF

AVERAGEIF

ResolvedVersion 2010

Wed 26 Apr 2017, 13:43 Delegate Andrew said...

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel Dashboards for Business Intelligence course

AVERAGEIF

Hi,
I have leave dates in Column A and Length of Service (LoS) in Column B.
I'd like to calculate the average LoS when there is no leave date in Column A (ISBLANK), so exclude any value in Column B when there is a value in Column B.

I've tried various methods but all I get is the average for ALL of Column B.

Can you help please?

Thanks,

A

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips

AVERAGEIF

AVERAGEIF

Excel articles

Excel tip:

Creating custom lists