Formula for sumifs with less than a date range

		Microsoft Office Forums > Microsoft Excel > Excel
Formula for sumifs with less than a date range

FAQ

Thread Tools

Display Modes

04-15-2015, 01:18 PM

lynchbro

Formula for sumifs with less than a date range

Windows 8

Office 2010 64bit

Advanced Beginner

Join Date: Jun 2014

Location: New York

Posts: 41

Quote:

Originally Posted by Pecoflyer

First trial, in cell Q7. The result isn't quite what you have but it looks close

thank you for your help! I actually was able to get it to work with my SUMIF function. Here is that argument.

=SUMIFS('Shareholder Transactions'!G:G,'Shareholder Transactions'!A:A,'Trial Balance'!C7,'Shareholder Transactions'!E:E,">"&'Trial Balance'!B7)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying "SUMIFS" formula	taryn	Excel	2	01-23-2015 05:41 AM
Restrict Date Range Calculations	akatz85	Excel	4	03-27-2014 08:46 PM
Date Range Prompt	MikeWooZ	Excel	6	12-04-2011 02:10 PM
Help needed using the serial number date with sumifs - whole office is stumped	FraserKitchell	Excel	3	01-06-2010 12:24 PM
Range Formula	aleksandr	Excel	10	05-18-2009 12:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:43 AM.