Excel Averageifs with date criteria

I have 2 sheet called sheet1 and the other sheet2.

Info found on sheet1 Using columns a-d

Date Product qty used actual qty used

1-jan-16 aaaa 102 50

8-jan-16 aaaa 102 150

Date = 1 jan + 8 day till dec 31

sheet2 info using columns a-d

Month count average

Jan

Feb

Mar

The count columns uses the =count function works ok

but the average error

This is what i'm trying to do is average out the actual column on sheet 1 using the month criteria on sheet2, so for the month Jan it looks at sheet1 and averages out the 4 week that have the month Jan found in it.

I get #DIV/0! error

=AVERAGEIFS('sheet1'!H157:H208,'sheet1'!B157:B208,">="&Sheet2!A4,'sheet1'!B157:B208,"<="&EOMONTH(Sheet2!A4,0))

If any info missing please feel free to ask. Thanks

Replay

Category: excel formula Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.211 (s). 12 q(s)