don't excel very well :(

[subs]

hi any of u excellent excel-ers know how to fix this please?

=COUNTIFS(F2=M$2$,(L2,"=true"))

just want a count if both things are true:

countif(F2=M$2$)
countif(L2,"=true")

then i want to be able to drag this down like 60 rows.

sorry for the stupidness but it annoying me now... man WR to betting, i wish i was born 10 years earlier or 10 years later grrrr.

easiest 50 points u ever made?

many thanks

[josie88]

COUNTIFS function isn't supported until office 2007. This should work for all versions:

=IF(COUNTIF(F2,$M$2)+COUNTIF(L2,"=true") =2,1,"")

If both conditions are true this will return a value of 1, otherwise cell will be left blank.

GL

[subs]

hi josie88 thanks for the help.

was not really the answer i was looking for because it only returned 1 or blank. i needed a total. but close. actually i screwed up the question, the answer is:

=COUNTIFS(L:L,"=TRUE",F:F,M2) so simple i can't believe it has taken me so long to do it....

thanks for ur help : )