Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ceiling formula
Hi,
I'm currently using the following formula:- =CEILING(SUMPRODUCT(--(A4=$B$10:$B$240),1/COUNTIF($J$10:$J$240,$J$10:$J$240&"")),1) It seems to be working, but if counting a few less items than there actually are. Does anyone know if there are flaws with this formula? I've checked manually and the count if a few numbers out. The cells it is reading are correct and I do the control, alt shift to make it work... any thoughts would be much appreciated thanks fiona |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use Ceiling to round? | Excel Discussion (Misc queries) | |||
MOD and Ceiling formula used to round up and down to 49 and 99 | Excel Discussion (Misc queries) | |||
ceiling | Excel Discussion (Misc queries) | |||
how to use the ceiling function | Excel Worksheet Functions | |||
Max, Ceiling, If, Etc | Excel Discussion (Misc queries) |