View Single Post
 
Old 09-03-2013, 03:16 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ok, first, to get the total from Sheet2 is simple: Use SUMIF instead of AVERAGEIF.

The number of months from 2012-06 to now: I'm sure there must be a built-in Excel function for that. Let me look... No, apparently not. But this article at Microsoft Support lists a formula that'll do it using the YEAR and MONTH functions.
Reply With Quote