Hi
I am hoping to count and value lines of information into parameters summarised in a Table
On the attached, I would like to count the number of days in column Q which fit into each range in column AH, e.g. count all days within 0>30, then sum all values within 0>30; and continue this exercise through to >365 on the table
I have attempted formula but been unsuccessful
If you can help it would be much appreciated
Thank you
Last edited by overbomb; 11-09-2017 at 06:36 AM. Reason: Solved
I would separate the min and max days into separate columns then use a simple COUNTIFS function for the Count and a SUMIFS function for the Value.
If you insist on keeping both numbers in the same cell, you can use these:
AI5 =COUNTIFS(Q:Q,">="&LEFT(AH5,FIND(">",AH5)-1)+0,Q:Q,"<="&MID(AH5,FIND(">",AH5)+1,LEN(AH5))+0) Dragged down through AI10
AI11 =COUNTIF(Q:Q,">365")
AJ5 =SUMIFS(R:R,Q:Q,">="&LEFT(AH5,FIND(">",AH5)-1)+0,Q:Q,"<="&MID(AH5,FIND(">",AH5)+1,LEN(AH5))+0) Dragged down through AJ10
AJ11 =SUMIF(Q:Q,">365",R:R)
Thank you so much for your help - such a relief
Will look at formula to understand logic
Many thanks, Lola
You're welcome. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks