Search results

I've been doing a bit of research on that myself, it's a way of forcing positive numerical values from the array. This article explains more: http://www.mcgimpsey.com/excel/formulae/doubleneg.html That's not to say I wouldn't appreciate any further explanation - learning is always good! :)

Thank you so much everyone for your quick replies, I'm spoilt for choice! The formula =SUMPRODUCT(--(A3:K3<$A$2:$K$2)) which Narayan provided got it working perfectly.

Hi Narayan, Yes sorry, what you have said above is exactly correct, I want to count how many tests S1 failed, then I can copy that formula down through all 250. --edit: your suggestion works like a charm! Thank you very much! :)

In fact I managed to improve the formula to: =COUNTIFS(A3,"<"&$A$2, B3, "<"&$B$2, C3,"<"&$C$2, D3,"<"&$D$2, E3,"<"&$E$2, F3,"<"&$F$2, G3, "<"&$G$2, H3,"<"&$H$2, I3,"<"&$I$2, J3,"<"&$J$2, K3,"<"&$K$2) Noticed the SUM was stupidly redundant. Still...

Hi everyone, Being a bit of an excel rookie I thought my best option would be to ask the pros! (I did try to work this one out myself first but the examples I have read about don't cover this issue very well). In the first row of each column from A-K I have a title for a number of tests...