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
Hello,
I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 states sara or jenny add and show on 2nd worksheet. Please help
I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 states sara or jenny add and show on 2nd worksheet. Please help
Related:
- Totaling amount from 1st tab depending on another column states
- 1st mass mailer - Download - Email
- Java update tab missing - Guide
- Samsung galaxy tab lock screen while watching video - Guide
- Opera incognito tab - Guide
- Edge open new tab as popup - 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