Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
CountIf from multiple sheets in another workbook
16 views
Skip to first unread message
JoshBrunz
May 15, 2013, 1:38:17 PM5/15/13
to
i have 1 workbook with about 20 sheets, i need to search this workbook
for a name in one column on each sheet. i made a list of the sheets in
the 2nd workbook in column a. i tried this formula in column b, but i
can't get it to recognize the cell in my formula:
=SUM(SUMIF(INDIRECT("'[cfshows.xls]&A2'!U:U"),"Brown, Bob"))
--
JoshBrunz
lhki...@comcast.net
May 15, 2013, 2:53:56 PM5/15/13
to
What do you want the formula to return once it finds the name in one of the sheets?
Regards,
Howard
lhki...@comcast.net
May 15, 2013, 3:53:52 PM5/15/13
to
>
> What do you want the formula to return once it finds the name in one of the sheets?
>
>
>
> Regards,
>
> Howard
Howard
JoshBrunz
May 15, 2013, 4:07:17 PM5/15/13
to
lhki...@comcast.net;1611847 Wrote:
> On Wednesday, May 15, 2013 10:38:17 AM UTC-7, JoshBrunz wrote:-
> > i have 1 workbook with about 20 sheets, i need to search this
> workbook
> >
> > for a name in one column on each sheet. i made a list of the sheets
> in
> >
> > the 2nd workbook in column a. i tried this formula in column b, but i
> >
> > can't get it to recognize the cell in my formula:
> >
> >
> >
> > =SUM(SUMIF(INDIRECT("'[cfshows.xls]&A2'!U:U"),"Brown, Bob"))
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> > JoshBrunz-
> workbook
> >
> > for a name in one column on each sheet. i made a list of the sheets
> in
> >
> > the 2nd workbook in column a. i tried this formula in column b, but i
> >
> > can't get it to recognize the cell in my formula:
> >
> >
> >
> > =SUM(SUMIF(INDIRECT("'[cfshows.xls]&A2'!U:U"),"Brown, Bob"))
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> >
>
> Hi Josh,
>
> What do you want the formula to return once it finds the name in one of
> the sheets?
>
> Regards,
> Howard
just a count of how many times the name bob brown appears in the U
> Hi Josh,
>
> What do you want the formula to return once it finds the name in one of
> the sheets?
>
> Regards,
> Howard
column on each page
--
JoshBrunz
lhki...@comcast.net
May 15, 2013, 7:13:42 PM5/15/13
to
> just a count of how many times the name bob brown appears in the U
>
> column on each page
Well, one way, on each sheet in a discreet cell enter this formula, (I used F1 on each sheet). Adjust formula to that sheet's name.
=COUNTIF(Sheet2!U:U,Sheet1!A2)
Bob Brown is in cell A2 of sheet1. And A2 could be a drop down with other names.
Then on sheet1 this formula =SUM(Sheet2:Sheet6!F1)
Where sheet2 is the first sheet and sheet6 is the last sheet.
Regards,
Howard
0 new messages