Help with SUMIFS

		Microsoft Office Forums > Microsoft Excel > Excel
Help with SUMIFS

FAQ

Thread Tools

Display Modes

05-27-2016, 07:42 AM

OTPM

Windows 7 32bit Help with SUMIFS

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Quote:

Originally Posted by jeffreybrown

Hi Tony,

Try

=SUMPRODUCT(--(MONTH($C$1)&"|"&YEAR($C$1)=MONTH(Sheet1!$E$6:$E$1 4)&"|"&YEAR(Sheet1!$E$6:$E$14)),--($A3=Sheet1!$A$6:$A$14),Sheet1!$I$6:$I$14)

Brilliant - many thanks Jeffrey.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumifs	lynchbro	Excel	1	07-02-2014 09:27 AM
Help with SUMIFS	LeFoah	Excel	2	10-20-2013 09:22 AM
SumIFS statement (not sure if it is right use)	sweetcuda	Excel	13	08-26-2013 11:09 AM
I need help with =SUMIFS	docwhit	Excel	2	01-05-2013 12:58 PM
SumIFS Questions	Kheinrich119	Excel	2	12-12-2012 10:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 AM.