Average between 2 dates if criteria appears in same row

[aceme73]

For each of our products, I am trying to calculate the average length of time between dates to respond to RFPs. I think it should be an AVERAGEIF or AVERAGE(IF formula but I cant find anything that works for what I am trying to do. I have uploaded an example of my spreadsheet.

I would like to get an average between B and C for each of the products listed in E. I have been fussing with this for hours and can't figure it out!

Thank you in advance for your knowledge and support!

[Tony Valko]

Try this array formula**:

=AVERAGE(IF(E3:E14=C19,C3:C14-B3:B14))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[aceme73]

Worked like a charm! Thank you so much

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.