Totaling amount from 1st tab depending on another column states
Closed
jenny
-
8 Jul 2016 à 20:38
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 9 Jul 2016 à 08:55
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 9 Jul 2016 à 08:55
Related:
- Totaling amount from 1st tab depending on another column states
- 1st mass mailer - Download - Email
- Excel column number - Guide
- Incognito tab opera - Guide
- Change new tab page chrome - Guide
- Reopen closed tab chrome - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
9 Jul 2016 à 08:55
9 Jul 2016 à 08:55
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
