Hi,

I asked this question last week but i think it got lost and i wasn't
descriptive enough with my question, so here we go again:
=SUM(IF('1'!B72,'1'!E2,0):IF('999'!B72,'999'!E2,0) ) that is what i want it
to do, but all it comes up with is ## when i hit enter. Essentially, i have
IF formulas that work great but instead of writing each sheet in (because I
will be adding more sheets in as time goes by) is there another way of doing
it?
=SUM(IF('1'!B72,'1'!E2,0)+IF('2'!B72,'2'!E2,0)+... +IF('999'!B72,'999'!E2,0))

So essentially, how do I add IF results from across spreadsheets? I have a
'sum' spreadsheet that I want to have IF functions 'summed' up on. Does this
make sense?

For example, on each worksheet, I have something similar to this:

How much did you like the course: 4
Workload was manageable: 3
RN: 1
Diploma nurse: (blank)

I need to separate (on the Sum sheet) between answers from RNs and answers
from Diploma. So my IF is whether or not RN = true (has a 1) and then the
number for the first question is the number if RN is true. Does this make
sense? So i have the IF part figured out, that's all good! But i just need
to add the IFs across all the spread sheets without having to enter them
individually in the formula on teh sum sheet. Is there a way?
Even a countif could work, but then i need the sum of countif.

Thanks!

-j