| Author | Thread |
|
|
11/28/2008 03:48:14 PM · #1 |
I'm almost done with the 2009FSM site but having a few problems with formulas. I'm looking for someone that may have the answer to this question.
I want to calculate how may times a user has participated through out the season. Normally I do this by the 'COUNTIF' statement. But that only works if all the cells are in a continues row or column. My problem is they are spaced out every 4 cells in each row. Is there a way to calculate how many FS a user has participated when skipping rows using the 'COUNTIF' statement. Or are there another statement that would do the job?
Example of what I have been using =COUNTIF(A1:A12,>0,) but I will not work if I use =COUNTIF(A1,A4,A7,etc,>0,)
I need the formula to add up each time a user enters the a FS challenge by argument of >0 (>0 would mean they entered or =true). That way when dividing the users FS entry scores it would only divide by the months entered - giving a correct average.
Thanks in advance,
Scott |
|
|
|
11/28/2008 03:58:52 PM · #2 |
| Could you use OR? =OR(A1>0,A4>0,A8>0) ETC. The result reads then as true I believe. Then you could use that true result to use a IF statement for another formula or the like. |
|
|
|
11/28/2008 04:18:04 PM · #3 |
Originally posted by DrAchoo:
Could you use OR? =OR(A1>0,A4>0,A8>0) ETC. The result reads then as true I believe. Then you could use that true result to use a IF statement for another formula or the like. |
let me try that and see
Thanks
Message edited by author 2008-11-28 16:18:13. |
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 08/31/2025 02:54:07 PM EDT.
