Sum ifs based on dates on two columns JMP 11

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Sum ifs based on dates on two columns JMP 11

Hi,

I have been to adapt and excel file where I used the SUMIFS argument to sum data if the date meets criteria from two different columns, I used the excel formula =SUMIFS(C:C,A:A,">="&A3,A:A,"<"&F3), but when I try it in JMP 11 I cannot seem to make it, even though I have tried a few suggestions from previous discussions on the topic.

Any recommendations?

Thanks

My data table is similar to this

Date Time StartSum(Number of customers)FinishOccupancy
7/13/2015 11:0027/13/2015 11:055
7/13/2015 11:0127/13/2015 11:066
7/13/2015 11:0417/13/2015 11:0910
7/13/2015 11:0537/13/2015 11:1011
7/13/2015 11:0627/13/2015 11:118
7/13/2015 11:0847/13/2015 11:139
7/13/2015 11:0927/13/2015 11:147
7/13/2015 11:1127/13/2015 11:166
7/13/2015 11:1217/13/2015 11:175
7/13/2015 11:1327/13/2015 11:185
7/13/2015 11:1417/13/2015 11:193
7/13/2015 11:1617/13/2015 11:214

Accepted Solutions
Solution
‎09-25-2015 11:41 PM
SAS Employee
Posts: 244

Re: Sum ifs based on dates on two columns JMP 11

You may have better luck with this question in the JMP User Community at community.jmp.com.

 

-Jeff

View solution in original post


All Replies
Solution
‎09-25-2015 11:41 PM
SAS Employee
Posts: 244

Re: Sum ifs based on dates on two columns JMP 11

You may have better luck with this question in the JMP User Community at community.jmp.com.

 

-Jeff

New Contributor
Posts: 2

Re: Sum ifs based on dates on two columns JMP 11

thanks Smiley Happy BIG help 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 200 views
  • 0 likes
  • 2 in conversation