AVERAGEIFS Formula help needed

[akira115]

Looking to get some help on an Averageifs. Not even sure if its the correct formula to use. Here's the situation.

I have 3 rows of data that are analyzed.

Column A = Date Range (MM/DD/YYYY)
Column B = Workflow Type, can have one of two values (Workflow A, Workflow B)
Column C = Number value

What im looking to do is Average the number value in Column C for only rows with "Workflow A" within a specific MONTH.

I've been using this to Average the number values for ALL rows within a given month:
{=AVERAGE(IF(MONTH(!A2:A100)=10,(C2:C100)))}

So what can I do to include a specific Workflow?

Thank you for any help! Much appreciated!

[alansidman]

Here's how to make it work with Averageifs

http://www.techonthenet.com/excel/fo...averageifs.php

[Kevin UK]

Hi akira115

Use the AVERAGEIFS, for example:

Please Login or Register  to view this content.

You can reference dates in cells istead of hard coding them in eg:

Please Login or Register  to view this content.

Where E1 = Start date. F1 = End date. G1 = either "Workflow A, Workflow B"

[akira115]

@Kevin UK,

This worked great, thank you very much!