Hi.
First post and I want to say right up front that I tried searching for what I want to do without any success.
I have a column with two values that I want a total sum on. Basically, here is what I have:
COLUMN B
Lot Number
COLUMN D
Cost
From Column B, I want any lot numbers of 1993 and 1455
Column E has the corresponding costs for each lot
Column B Column E
1455 $2.00
1455 $3.00
1367 $2.00
1909 $4.00
1993 $5.00
1455 $3.00
1689 $1.00
1367 $1.00
1455 $4.00
In my example, I want to pull the prices from 1455 and 1993. The total should be $17.00 if I added everything together correctly. That sum (along with the working formula) would go into cell G2.
Here is what I have been playing with which returns $0.00
=SUMIFS(E2:E39,B2:B39,"=1113",B2:B39,"=1114")
I'm thinking I need an "AND" statement or something....
Mike
Bookmarks