#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Here is how is should work See Attach bill101 =SUMIFS
Quote:
Here is how is should work See Attach bill101 =SUMIFS |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |