If cells are blank leave blank if not average the range

[Mtommo]

Hi,
I have a table with 3 columns 1st is Qty, 2nd is Time, 3rd is average.
when i enter data in columns 1 & 2, (qty 500 & Time 6:45) column 3 gives me the average of 74.07.
I need a formula to say "if Column 2 (Time), cells B3:B3 is blank leave blank, if any data in Column 3, C3:C31 then average cells in column 3 C3:C31)"

see attachment

cheers
Mike

 

[etaf]

not sure i'm following what you need , other members may help
you mention 3 columns and show 5

you then give a different example

(qty 500 & Time 6:45) column 3 gives me the average of 74.07.

how do you get an average of 74.07 ???

cells B3:B3 is blank leave blank,

I assume you mean B3:B31 - so if any are blank - then result is blank

if any data in Column 3, C3:C31 then average cells in column 3 C3:C31)"

BUT not if any cells in B3:B31 are blank ....

Or do you want the average of whatever is in C3:C31 - BUT only if the corresponding cell B3:B31 is NOT blank

=Averageifs()

BUT as i say not sure what you want -
and you are showing TIME in 5th column - so average of the time - does the time also include a date - format using DD/MM/YY HH:MM

Book12
	A	B	C	D	E
1
2					3
3		X	2
4			3
5		X	4
6			5
7
8
9
Sheet1

Cell Formulas
Range	Formula
E2	E2	=AVERAGEIFS(C3:C31,B3:B31,"<>")