Thanks:  0
Likes:  0

# Thread: Somebody pls help me!!

1. A B C
1 Full Planned 150
2 Full Actual 148
3 Part Planned 50
4 Part Actual 39
5 Full Planned 150
6 Full Actual 162

How can I have the sum of "Full" "Actual" that equals 310?

2. Assuming that the numbers are in column A and "Full", etc...are in column B, enter the following formula in the formula bar and press ctrl-shift-enter (same time):

Code:
`=SUM((B1:B6="Full")*(C1:C6="Actual")*D1:D6)`
Hope this helps.

3. Edited (information in 2 columns)

310 =SUMPRODUCT((A1:A6="Full")*(B1:B6="Actual")*(C1:C6))
310 =SUMPRODUCT((A1:A6=F1)*(B1:B6=G1)*(C1:C6))

look at Sumif in Help

310 =SUMIF(B1:B6,"Full Actual",C1:C6)

with criteria in E1
310 =SUMIF(B1:B6,E1,C1:C6)

Revise cell references as necessary

[ This Message was edited by: Dave Patton on 2002-05-01 09:31 ]

4. If 1 & Full are in the same cell use the following in the formula bar:

Code:
`=SUM((MID(A1:A6,3,4)="Full")*(B1:B6="Actual")*C1:C6)`
And press ctrl-shift-enter at the same time.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-01 09:44 ]

5. Thank You guys!!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•