I need to sum one coloum with two different criteria. I tried sumifs and cant figure it out.
Example
A b c d e f
12:00 AM 10/1/15 12:14 AM 0 0 Thursday
12:15 AM 10/1/15 12:29 AM 0 0 Thursday
12:30 AM 10/1/15 12:44 AM 0 0 Thursday
12:45 AM 10/1/15 12:59 AM 0 0 Thursday
I am trying to sum the numbers in "D" that are for the dates in coloum "F" for only the time frame in coloum "A". IE. sum all the thursdays from 12am, sum all the thursdays from 12:15. ETC.. There are over 6400 rows of data.
try
=SUMIFS(D1:D4,F1:F4,"Thursday",A1:A4,TIME(0,0,0)) for 12:00 AM
=SUMIFS(D1:D4,F1:F4,"Thursday",A1:A4,TIME(0,15,0)) for 12:15 AM
Didn't seem to work. What I did is I created a value coloum and drop down menu's. A little more time consuming but I will get the results I am looking for.
Thank you
Post a SMALL sample file and show us what results you expect.
20 rows worth of data is plenty. We don't want to have to wade through 100's or 1000's of rows worth of data to test possible solutions.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks