...@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
>
> Sunnie
>
>
>
>
>
>
>
> From: Dilip Pandey [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
>
>
&g
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
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"),
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 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
> different rang
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 Wagner"
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 wrote:
> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different
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 wrote:
> Hi Dilip,
> The formula only returned the first sheet, I need it to sum all sheets
> with reference to different ranges for th
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 u