Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2013, 11:37 AM
docwhit docwhit is offline I need help with =SUMIFS Windows 7 64bit I need help with =SUMIFS Office 2010 64bit
Novice
I need help with =SUMIFS
 
Join Date: Jan 2013
Posts: 2
docwhit is on a distinguished road
Default I need help with =SUMIFS

In E21 is my SUMIFS But it stays like this



=SUMIFS($D$74:$D$958,$C$74:$C$958,C$21,$E$74:$E$95 8,$G41)


Should Look Like This
=SUMIFS(Expenses[Amount],Expenses[Category],I$40,Expenses[Month],$G41)



and in E39 to E41
Should be =MONTH([@Date]) That will Show the Month 1... At A39 to A41
But I cant get it to Cal...

Dose anyone Know what I need to Do or How I need to Inbed this..
I did this for 2012 Bills But Cant Remmber what I did to make it work...

Whit
Attached Files
File Type: xlsx cu2013234.xlsx (14.5 KB, 8 views)
Reply With Quote
  #2  
Old 01-04-2013, 12:08 AM
Kevin@Radstock Kevin@Radstock is offline I need help with =SUMIFS Windows 7 32bit I need help with =SUMIFS Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi docwhit

Try the following in E21, copy across & down.

SUMIFS:
=SUMIFS($D$39:$D$50,$A$39:$A$50,">="&EOMONTH("01/"&$C21&"/2013",-1)+1,$A$39:$A$50,"<="&EOMONTH("01/"&$C21&"/2013",0),$C$39:$C$50,E$20)

Or a SUMPRODUCT:
=SUMPRODUCT(--(MONTH($A$39:$A$50)=$C21),--($C$39:$C$50=E$20),$D$39:$D$50)

Kevin
Reply With Quote
  #3  
Old 01-05-2013, 12:58 PM
docwhit docwhit is offline I need help with =SUMIFS Windows 7 64bit I need help with =SUMIFS Office 2010 64bit
Novice
I need help with =SUMIFS
 
Join Date: Jan 2013
Posts: 2
docwhit is on a distinguished road
Default Here is how is should work See Attach bill101 =SUMIFS

Quote:
Originally Posted by Kevin@Radstock View Post
Hi docwhit

Try the following in E21, copy across & down.

SUMIFS:
=SUMIFS($D$39:$D$50,$A$39:$A$50,">="&EOMONTH("01/"&$C21&"/2013",-1)+1,$A$39:$A$50,"<="&EOMONTH("01/"&$C21&"/2013",0),$C$39:$C$50,E$20)

Or a SUMPRODUCT:
=SUMPRODUCT(--(MONTH($A$39:$A$50)=$C21),--($C$39:$C$50=E$20),$D$39:$D$50)

Kevin

Here is how is should work See Attach bill101 =SUMIFS
Attached Files
File Type: xlsx BILLS101.xlsx (62.0 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need help with =SUMIFS SumIFS Questions Kheinrich119 Excel 2 12-12-2012 10:00 AM
Help needed using the serial number date with sumifs - whole office is stumped FraserKitchell Excel 3 01-06-2010 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft