Tags: across, column, equals, excel, feb, function, jan, john, mar, microsoft, msdn, sheets, software, sum

SUM column A, IF column B=?, 3 sheets

On Microsoft » Microsoft Excel

1,164 words with 1 Comments; publish: Wed, 04 Jun 2008 12:08:00 GMT; (30693.75, « »)

SUM of column A, if column B equals "John" across three sheets.

What function should I use?

Thank you.

Three sheets, such as Jan.Feb.Mar.

A B

1 John

2 John

1 John

2 Sue

1 Sue

1 John

2 Matt

John has 5. Three duplicate sheets would equal 15

--

Message posted from http://www.ExcelForum.com

All Comments

Leave a comment...

  • 1 Comments
    • Hi

      first enter your sheet names in a separate range on your summary sheet.

      e.g. in the cells X1:X3

      After this use the following formula

      =SUMPRODUCT(SUMIF(INDIRECT("'" & X1:X3 &

      "'!B1:B100"),"John",INDIRECT("'" & X1:X3 & "'!A1:A100")))

      Regards

      Frank Kabel

      Frankfurt, Germany

      > SUM of column A, if column B equals "John" across three sheets.

      > What function should I use?

      > Thank you.

      >

      > Three sheets, such as Jan.Feb.Mar.

      > A B

      > 1 John

      > 2 John

      > 1 John

      > 2 Sue

      > 1 Sue

      > 1 John

      > 2 Matt

      > John has 5. Three duplicate sheets would equal 15.

      >

      > --

      > Message posted from http://www.ExcelForum.com/

      #1; Wed, 04 Jun 2008 12:09:00 GMT