Hi Susan,
The result calculated is 2 which is correct as only two rows, mentioned
below, are having the results (i.e., 1) as per your criteria :-
row # 5 of sheet1
row #16 of sheet 2
Now, some of our group members have also provided more power packed
formulas, using which you can get your query
[mailto:dilipan...@gmail.com]
Sent: Monday, July 04, 2011 3:27 AM
To: excel-macros@googlegroups.com
Cc: sunni...@gmail.com
Subject: Re: $$Excel-Macros$$ Sumif across multiple worksheets
Hi Susan,
The result calculated is 2 which is correct as only two rows, mentioned
below, are having
...@gmail.com
Subject: Re: $$Excel-Macros$$ Sumif across multiple worksheets
Hi Susan,
The result calculated is 2 which is correct as only two rows, mentioned
below, are having the results (i.e., 1) as per your criteria :-
row # 5 of sheet1
row #16 of sheet 2
Now, some of our group members
Hello Susan,
If you just have 3 sheets, Sheet1, Sheet2 Sheet3. use this;
=SUMPRODUCT(SUMIF(INDIRECT('Sheet{1,2,3}'!D:D),C
Wagner,INDIRECT('Sheet{1,2,3}'!E:E)))
Or,
Enter all sheet names in a range, say in J2:J3, then use this;
=SUMPRODUCT(SUMIF(INDIRECT('$J$2:$J$4'!D:D),C
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to different ranges for the same criteria , and summing
different ranges.
I tried SUMPRODUCT(SUM(IF...
I tried SUM(IF and inserting a + before each proceeding IF
Neither of those worked.
What about
see if it helps
SUMIF($D$2:$D$81,G3,E2:E81)+SUMIF(Sheet3!D:D,Sheet1!G3,Sheet3!E:E)+SUMIF(Sheet2!D:D,Sheet1!G3,Sheet2!E:E)
On Sat, Jul 2, 2011 at 9:52 PM, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to
Dear Susan,
You select all sheets(Group it ) and then try this formula.You may get
result in all sheets
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 9:52 PM, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with
Hi Susan,
Here's two ways to solve it
1. With a simple combo of sumif formulas
=SUMIF(D2:D6,C Wagner,E2:E6)+SUMIF(Sheet3!D11:D18,C Wagner,Sheet3!
E11:E18)+SUMIF(Sheet2!D13:D23,C Wagner,Sheet2!E13:E23)
2. With an array formula.
{=SUM((D2:D11=C Wagner)*(E2:E11)+(Sheet3!D11:D20=C
I mean copy without the curly braces. They are inserted by Excel when
you use the CSE keys
On Jul 2, 9:22 pm, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with reference to different ranges for the same criteria , and summing