Numbers won't add up

[JHC]

Hi



NOTE


Data is captured into the green fields (M12>M40) as per attached worksheet. The results for these input fields are displayed in the first table (rows 50>74).


I want to:


1. Add up all the results obtained in all the "Total" Columns, i.e. H50:H74, K50:K74, ......... AC50:AC74, etc. and display the results in H75, K75, ..... AC75 respectively.

2. In addition, the totals for the different columns must be added up and displayed in BL75.


Each time, however, I'm getting a #VALUE! ERROR pointing towards a wrong data type.


What would I have to change in order to make adding possible?


Thank you very much.

[rajeshturaha]

In f50 the formula need to be corrected
=IF(M12<=0,"",IF(M12<=70,"1",IF(M12>70,"")))
Place 0 in place of ""in all the formulas

Please Login or Register  to view this content.

Then put summarize your data in all the "Total" Columns, i.e. H50:H74, K50:K74, ......... AC50:AC74, etc.

[JHC]

Thank you for your prompt response, RT. Changed, tested and working.

[rajeshturaha]

Glad it helped u.
If u have the desired answer, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.