Solved
New Contributor
Posts: 2

# 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 Start Sum(Number of customers) Finish Occupancy 7/13/2015 11:00 2 7/13/2015 11:05 5 7/13/2015 11:01 2 7/13/2015 11:06 6 7/13/2015 11:04 1 7/13/2015 11:09 10 7/13/2015 11:05 3 7/13/2015 11:10 11 7/13/2015 11:06 2 7/13/2015 11:11 8 7/13/2015 11:08 4 7/13/2015 11:13 9 7/13/2015 11:09 2 7/13/2015 11:14 7 7/13/2015 11:11 2 7/13/2015 11:16 6 7/13/2015 11:12 1 7/13/2015 11:17 5 7/13/2015 11:13 2 7/13/2015 11:18 5 7/13/2015 11:14 1 7/13/2015 11:19 3 7/13/2015 11:16 1 7/13/2015 11:21 4

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

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

Posted in reply to JeffPerkinson_JMP

thanks BIG help

🔒 This topic is solved and locked.

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

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