About Us

Centauro

hi i new to this so don't be to hard on me :) I have to sum several cell whit
this formula on it,
=(IF(C13=0,0,AC1)+IF(D13=0,0,AC2)+IF(F13=0,0,AC2)) *(IF(OR(N13="P",N13="M"),1,0)+IF(OR(O13="P",O13="M "),1,0)+IF(OR(P13="P",P13="M"),1,0)+IF(OR(Q13="P", Q13="M"),1,0)+IF(OR(R13="P",R13="M"),1,0)+IF(OR(S1 3="P",S13="M"),1,0)+IF(OR(T13="P",T13="M"),1,0)+IF (OR(U13="P",U13="M"),1,0)+IF(OR(V13="P",V13="M"),1 ,0)+IF(OR(W13="P",W13="M"),1,0)+IF(OR(X13="P",X13= "M"),1,0)+IF(OR(Y13="P",Y13="M"),1,0))

and then

=SUM(AE13:AE24)

tks in advance

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Simplify Formula	Mike Lewis	Excel Worksheet Functions	1	July 4th 08 02:00 AM
Is there anyway to simplify this formula?	rancher fred	Excel Worksheet Functions	1	January 6th 07 09:29 PM
simplify this formula??	Dave F	Excel Discussion (Misc queries)	6	September 27th 06 05:28 PM
Simplify formula	tjtjjtjt	Excel Worksheet Functions	5	September 23rd 06 02:25 PM
Simplify formula	Luke	Excel Worksheet Functions	37	May 6th 05 07:21 AM

Menu

About Us