# sumifs when criteria is met...sum up to total

1. ## sumifs when criteria is met...sum up to total

Hi,
need assistance on this code
=SUMIFS(rway_bom!\$A\$1:\$A\$50,"TRAY",rway_bom!\$B\$1:\$B\$50,"straight",rway_bom!\$E\$1:\$E\$50,"8"=sum(rway_bom!\$D\$1:\$D\$50))

after all the criteria is met i want to add the total
rway_bom (data sheet)
sheet 1 is where i want to total to show

(rway_bom)
a1 to a50 looks for TRAY (criteria 1)
b1 to b50 looks for straight (criteria 2)
e1 to e50 looks for 8 (criteria 3)
if all is met
d1 to d50 add all for total to be shown on sheet 1

Help

2. ## Re: sumifs when criteria is met...sum up to total

This should do it:

Formula:
`Please Login or Register  to view this content.`

You can also use absolute references and cells to hold the criteria....I used C1 to C3 for the criteria in this formula that does exactly the same thing as the first formula except that the ranges are absolute and the criteria are in cells so that different criteria can be used without going into the formula to make changes.

Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1