problem with cell names

  • Thread starter Thread starter Tom G
  • Start date Start date
T

Tom G

I have the following formula:

=SUMIF(SCHOOL,SCH_NUM,V_R)/COUNTIF(SCHOOL,SCH_NUM)

this figures out the mean of V_R for SCHOOL = SCH_NUM, where V_R, SCHOOL, &
SCH_NUM are names.


I also want to use the following formula:

=SUMIF(SCHOOL,"<>SCH_NUM",A_D)/COUNTIF(SCHOOL,"<>SCH_NUM")

it seems that the phrase "<>SCH_NUM" does not connect to the cell with that
name.

Any suggestions?

Thanks,
tom
 
Tom,

Try a formula like


=SUMIF(SCHOOL,"<>"&SCH_NUM,A_D)/COUNTIF(SCHOOL,"<>"&SCH_NUM)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top