Help

[Mike]

We are creating a spread sheet where we are going to have
a total number of points scored and a total number of
points possible. However, not all categories apply in
each grouping. We need a formula that will calculate
points possible without adding in the not applicable areas
point values.

 

[AlfD]

Hi!

I'm sure it can be done but more info is needed on where the point
come from, how they are combined, where are the N/A areas and how woul
I recognise them.

Give us a sample (here, not in an attachment)...

Al

 

[mzehr]

Hi Mike,
You will probably need to add a helper column, and flag
those records which need to be added together. Then you
could use a sumif, or sumproduct formula to finish the
project.

Note though that if you use sumproduct, it cannot use
wildcards, or reference an entire column, as you can with
sumif. However, sumif also has its limitations, as it
does not work with a closed workbook, if you are spanning
workbooks with your formula. Both are extremely powerful,
and will probably do the trick for you.

HTH