SUMIF

Someone please tell me why my SUMIF formula is not pulling in the data.  I ran a trim mitigating space exposure.  
H387-mat-act-to-est.xls
PeteymeiserAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
you havent fixed your range because of which its not working...
use this rather
=SUMIF(Sheet1!A:A,D2,Sheet1!D:D)
it will do what you are looking for...or fixed your ranges by applying dollar sign over it...
Saurabh...
0
 
PeteymeiserAuthor Commented:
That was it.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.