Hello all,
I am working on an Excel file that will only require Soldiers to input gender, age group, and raw scores to compute their APFT (army physical fitness test) scores. For some reason, when I input a raw run time that will give a run score that is a multiple of 10, the values are returned as "0." I have been troubleshooting and picking my brain for several hours to no avail. Any help? Here is the formula:
=SUMIFS(Running_points,Running_gender,C19,Running_age,D19,Running_Time,L19)
running_points, gener, age, and time are all the same number of rows and any time that gives a score that is not a multiple of 10 displays properly. I don't know how to upload the excel file to the forum, but I am willing to send it to someone for some troubleshooting if needed. This will be a tremendous asset to my unit if I can just get the dang thing to work!
Thanks,
krntkd
I am working on an Excel file that will only require Soldiers to input gender, age group, and raw scores to compute their APFT (army physical fitness test) scores. For some reason, when I input a raw run time that will give a run score that is a multiple of 10, the values are returned as "0." I have been troubleshooting and picking my brain for several hours to no avail. Any help? Here is the formula:
=SUMIFS(Running_points,Running_gender,C19,Running_age,D19,Running_Time,L19)
running_points, gener, age, and time are all the same number of rows and any time that gives a score that is not a multiple of 10 displays properly. I don't know how to upload the excel file to the forum, but I am willing to send it to someone for some troubleshooting if needed. This will be a tremendous asset to my unit if I can just get the dang thing to work!
Thanks,
krntkd