i have a row with M,M1.M2,M3,T,T2,T3,N
i want to be able count them and make the M,T,M1,T1,N worth 8,5 and the M2,M3,T2,T3 worth 4 and sum all up in the end, i tried like this but didnt count right, can anyone help me pls, ty in advance
=SUM(COUNTIF(C7:AG7,"M")+COUNTIF(C7:AG7,"M1")+COUNTIF(C7:AG7,"T")+COUNTIF(C7:AG7,"T1")+COUNTIF(C7:AG7,"N")*8,5+SUM(COUNTIF(C7:AG7,"T2")+COUNTIF(C7:AG7,"T3")+COUNTIF(C7:AG7,"M2")+COUNTIF(C7:AG7,"M3")))*4
OK, no commas for decimal places! (OK, maybe that works LOL)
You need to wrap your sums with parenthesis before you multiply them by the 8.5 or 4
Last edited by mike65535; 08-01-2013 at 08:42 AM.
=8.5*(sum(countif(c7:ag7,"m")+countif(c7:ag7,"m1")+countif(c7:ag7,"t")+countif(c7:ag7,"t1")+countif(c7:ag7,"n")))+
4*(sum(countif(c7:ag7,"t2")+countif(c7:ag7,"t3")+countif(c7:ag7,"m2")+countif(c7:ag7,"m3")))
i tryed that but only get "###" as result on the cellOriginally Posted by mike65535
Generally, all # symbols means the column is too narrow for the result. Widen it.
gives me error 508, wasnt only #'s i google it and it says it has too many arguments, how can i reduce or do it on another way so it does give the error?
Try changing the 8.5 to 8,5 or whatever scheme works in your configuration
tried that didnt seem to work, can i google doc share it with u so u can give a look?
hmm wait i think it was my bad i was using openoffice when i putted that on google docs worked somehow i think, gonna check if its right, TYTY
ok all working good now TY U SO MUCH MIKE
Last edited by sakkin; 08-07-2013 at 08:32 AM.
No, 41 is correct.
M3 counts 4 and there's 6 of them = 24
M1 counts 17/2 and there's 2 of them = 17
24+17 = 41
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks