Totaling amount from 1st tab depending on another column states

[Closed]
Report
-
Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
-
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


1 reply

Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
145
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