Hi all,
I have a sheet which has 5 values in cells C32, F32, I32, L32 and O32. The number is always between 0 and 35. I want a formula to look at those 5 cells and tell me what percentage of the results are between 0 - 15, 16 - 29 and 30+. I've tried lots of variations but getting nowhere fast. A25 is the first cell data would be entered into so if blank, I want no error.
The formula I'm at so far is shown below:
=IF(ISERROR(IF(ISBLANK(A25),"0 - 15 mins = 0% 16 - 29 mins = 0% 30+ mins = 0%",CONCATENATE(" 0 - 15 mins = ",TEXT(COUNTIF(C32+F32+I32+L32+O32,1),"0%")," 16 - 29 mins = ",TEXT(COUNTIF(C32+F32+I32+L32+O32,2),"0%")," "," 30+ mins = ",TEXT(COUNTIF(C32+F32+I32+L32+O32,3),"0%")))
Anyone any ideas?
TIA
Jack
Bookmarks