Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing up various Worksheets to one Summary sheet using variables
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing up various Worksheets to one Summary sheet using variables
Terri,
can you try using the below formula in Sheet1 B3 =IF(AND(Sheet2!B3="Boy",Sheet2!C3="Girl"),Sheet2!D 4,"") Yes you can do it for multiple worksheets -kc *Click YES if this helps "Terri" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing multiple validated sheets into a summary sheet | Excel Worksheet Functions | |||
link few worksheets in one summary sheet | Excel Discussion (Misc queries) | |||
Summary sheet for multiple worksheets | Excel Discussion (Misc queries) | |||
Summary sheet for 80+ tabs/worksheets | Excel Discussion (Misc queries) | |||
How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) |