SumIFs Problem

M

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
2,681
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
I want to give sum of working time at Time Period from Date N1 to Date O1. formula writes in N2 Cell.
This is Formula : =SUMIFS($J:$J,$L:$L,1,$B:$B,B3,$F:$F,$N$1,$F:$F,$O$1)
what is problem answer is zero


<tbody>
ABCDEFGHIJKLMNO
1Row No.Card No.Card&Row No.First NameLast NameDateWeek DayInput TimeOutput TimePresence TimeCharged SentryTotal days Report>=3/20/2014<=3/31/2014
21100100001MohammadAhmadi3/20/2014Thursday10:58:0022:15:0011:17:00Sunday Shift 410
32100100002MohammadAhmadi3/23/2014Sunday10:25:0015:00:0004:35:00Sunday Shift 41
43100100003MohammadAhmadi3/28/2014Friday10:00:0016:00:0006:00:00Sunday Shift 41
54100100004MohammadAhmadi3/31/2014Monday13:00:0017:00:0004:00:00Sunday Shift 41
65100100005MohammadAhmadi4/1/2014Tuesday12:00:0015:00:0003:00:00Sunday Shift 41
76100100006MohammadAhmadi4/3/2014Thursday09:40:0021:00:0011:20:00Sunday Shift 41
81102102001QasemSaadatvand3/29/2014Saturday11:20:0015:00:0003:40:00Saturday Shift 31
92102102002QasemSaadatvand3/30/2014Sunday11:00:0015:30:0004:30:00Saturday Shift 31
103102102003QasemSaadatvand3/31/2014Monday11:00:0015:00:0004:00:00Saturday Shift 31
114102102004QasemSaadatvand4/1/2014Tuesday11:00:0014:30:0003:30:00Saturday Shift 31
125102102005QasemSaadatvand4/2/2014Wednesday11:00:0015:20:0004:20:00Saturday Shift 31

<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>
</tbody>


Thanks
Maabadi
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
This is table
ABCDEFGHIJKLMNO
1Row No.Card No.Card&Row No.First NameLast NameDateWeek DayInput TimeOutput TimePresence TimeCharged SentryTotal days Report>=3/20/2014<=3/31/2014
21100100001MohammadAhmadi3/20/2014Thursday10:58:0022:15:0011:17:00Sunday Shift 410
32100100002MohammadAhmadi3/23/2014Sunday10:25:0015:00:0004:35:00Sunday Shift 41
43100100003MohammadAhmadi3/28/2014Friday10:00:0016:00:0006:00:00Sunday Shift 41
54100100004MohammadAhmadi3/31/2014Monday13:00:0017:00:0004:00:00Sunday Shift 41
65100100005MohammadAhmadi4/1/2014Tuesday12:00:0015:00:0003:00:00Sunday Shift 41
76100100006MohammadAhmadi4/3/2014Thursday09:40:0021:00:0011:20:00Sunday Shift 41
81102102001QasemSaadatvand3/29/2014Saturday11:20:0015:00:0003:40:00Saturday Shift 31
92102102002QasemSaadatvand3/30/2014Sunday11:00:0015:30:0004:30:00Saturday Shift 31
103102102003QasemSaadatvand3/31/2014Monday11:00:0015:00:0004:00:00Saturday Shift 31
114102102004QasemSaadatvand4/1/2014Tuesday11:00:0014:30:0003:30:00Saturday Shift 31
125102102005QasemSaadatvand4/2/2014Wednesday11:00:0015:20:0004:20:00Saturday Shift 31

<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="4"></colgroup><tbody>
</tbody>
 
Upvote 0
Possibly a from-to problem...

=SUMIFS($J:$J,$L:$L,1,$B:$B,B3,$F:$F,">="&$N$1,$F:$F,"<="&$O$1)<strike></strike>
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

C
  • Question
Ordinary Hours or Penalty Shift
Replies
0
Views
76
ChetanPuri
C
C
  • Solved
Convert and copy to Date
Replies
5
Views
110
Micron
M
M
  • Question
Complexed Time Difference Formula
2
Replies
17
Views
1K
mahmed1
M
C
  • Question
Calculate and Identify Ordinary Hours, Double time or 1.5 Time
Replies
0
Views
72
ChetanPuri
C
C
  • Solved
Calculate difference b/w numbers
Replies
3
Views
138
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,974
Messages
6,122,536
Members
449,088
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top