• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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
0
Peteymeiser
Asked:
Peteymeiser
1 Solution
 
Saurabh Singh TeotiaCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now