| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif formula
Hi
is it possible to write a sumif formula to get data from two sheet at the same time. I want to look for "A4" from Sheet1 & Sheet2 at the same time. the idea here is if "A4" is in both tabs than give me the sum figure. Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif formula
Just string 2 SUMIFs together:
=SUMIF(Sheet1!A1:A10,"A4",Sheet1!B1:B10)+SUMIF(She et2!A1:A10,"A4",Sheet2!B1:B10) -- Biff Microsoft Excel MVP "Rohit" wrote in message ... Hi is it possible to write a sumif formula to get data from two sheet at the same time. I want to look for "A4" from Sheet1 & Sheet2 at the same time. the idea here is if "A4" is in both tabs than give me the sum figure. Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif formula
Use your sumif formula like this...
=SUMIF(Sheet2!A:A,Sheet1!A4,Sheet2!B:B)+SUMIF(Shee t3!A:A,Sheet1!A4,Sheet3!B:B) If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Rohit" wrote: Hi is it possible to write a sumif formula to get data from two sheet at the same time. I want to look for "A4" from Sheet1 & Sheet2 at the same time. the idea here is if "A4" is in both tabs than give me the sum figure. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf Formula | Excel Worksheet Functions | |||
| Help with sumif formula please | Excel Discussion (Misc queries) | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Linear Mode
