counting a range based on nth cell

Hi everyone i have a tricky one,

basicall only count (M3:AJ3), if (AP16) is more than 3

but if AP16 is 3 or less only count M3:Z3

is there a formula for this ?

Thankyou!

thankyou! that worked quite well, i was also wondering if there is a way to..

only count (M3,T3,V3:Z3,AB3:AD3,AG3:AH3,AJ3), if (AP16) is less than 3

thankyou in advance

Thankyou atul, sothis is the formula I have

=IF(AQ28<=4,COUNTA(M3,T3,V3:Z3,AB3:AD3,AG3:AH3,AJ3),"")

is it possible (AM) to only multiply range M3,T3,V3:Z3 by 5 so that only data appearing under them is x5 the value? so it looks something like this =IF(AQ28<=4,COUNTA(((M3,T3,V3:Z3)*5),AB3:AD3,AG3:AH3,AJ3),"") ( but obviously its not giving the correct out put)

if the original formula has an output of 3, I would like to have the 5 multiplier to have the answer as 11

thank you again

please see attached document with dummy solution

thankyou both jetemc and protonleah, sorry AQ28 should have been AQ16.

=IF(AQ16<=4,SUMIFS(M3:Z3,M$2:Z$2,"technical error*")*5+SUMIFS(AA3:AJ3,AA$2:AJ$2,"technical error*"),"") - worked perfectly, I do have one last question though


is there a way to integrate this formula...

=IFERROR(INDEX(Sheet2!$AK$3:$AK$13,MATCH($B5,Sheet2!$A$3:$A13,0)),"")

to have it process the below?

to have Sheet 1 column H Populates data from Sheet 2 AK.. unless there is data in AL- then have sheet 1 Column H populate data from Sheet2 AL.

there is an example solution attached