Summing up various Worksheets to one Summary sheet using variables

T

Terri

I am trying to sum up values from a different worksheet within the workbook
but what I want to sum up is:

Work sheet 2: is the data that I will be pulling from

Work Sheet 1: is my summary in Cell B3
I want it to sum up from Work sheet 2 = if Cell B3 says "Boy" and if cell
C3 says "Girl" then take total from D4 and place in cell B3 in worksheet 1
(work sheet 2 cells B3 and C3 have drop down Variations)

and is it possible to take the above formula and do multiple worksheets to
add up the same formula?

Hope this makes sense ?
 
K

KC

Terri,
can you try using the below formula in Sheet1 B3
=IF(AND(Sheet2!B3="Boy",Sheet2!C3="Girl"),Sheet2!D4,"")

Yes you can do it for multiple worksheets

-kc
*Click YES if this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top