Totaling amount from 1st tab depending on another column states
Closed
jenny
-
Jul 8, 2016 at 08:38 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 9, 2016 at 08:55 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 9, 2016 at 08:55 AM
Related:
- Totaling amount from 1st tab depending on another column states
- 1st mass mailer - Download - Email
- Java update tab missing - Guide
- Opera incognito tab - Guide
- Samsung galaxy tab lock screen while watching video - Guide
- Chrome close tab shortcut android - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 9, 2016 at 08:55 AM
Jul 9, 2016 at 08:55 AM
jenny, Good morning.
Suppose:
Sheet 1
A1:A10 --> $
B1:B10 --> Names
Sheet 2
A1 --> Formula
=SUMPRODUCT(((Sheet1!B1:B10="sara")+(Sheet1!B1:B10="jenny"))*(Sheet1!A1:A6))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
Sheet 1
A1:A10 --> $
B1:B10 --> Names
Sheet 2
A1 --> Formula
=SUMPRODUCT(((Sheet1!B1:B10="sara")+(Sheet1!B1:B10="jenny"))*(Sheet1!A1:A6))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
