- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help-Sumif and Vlookup?
Posted on 8/3/15 at 9:44 am
Posted on 8/3/15 at 9:44 am
I'm having trouble figuring out this formula. It's probably really easy but I'm drawing a blank this Monday morning.
I want to get the sum of all "Additional Building (carts)" items from Sheet 2 onto Sheet 1. The amounts totaling would be coming from Sheet 2 column J. Any ideas would help or if you need more info I can give you that too.
Sheet 1
Sheet 2
I want to get the sum of all "Additional Building (carts)" items from Sheet 2 onto Sheet 1. The amounts totaling would be coming from Sheet 2 column J. Any ideas would help or if you need more info I can give you that too.
Sheet 1
Sheet 2
Posted on 8/3/15 at 9:51 am to tigers444
=SUMIF(Sheet2!C1:C30,B4,Sheet2!J1:J30)
Posted on 8/3/15 at 9:51 am to tigers444
=SUMIF(Sheet2!C2:Cwhatever,"Additional Building (Carts)",Sheet2!J2:Jwhatever)
edit: be sure the job category is the same, or they won't get counted.
referencing it from B4 as above is a good idea.
edit: be sure the job category is the same, or they won't get counted.
referencing it from B4 as above is a good idea.
This post was edited on 8/3/15 at 9:58 am
Posted on 8/3/15 at 10:20 am to Dooshay
I knew I was overthinking this. Thanks to both for the help!
Back to top
Follow TigerDroppings for LSU Football News