UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sum, Any Version    
 
   
access2009eg
post Nov 18 2019, 08:18 PM
Post#1



Posts: 1,134
Joined: 19-February 08



Hello friends
I want to sum 2 cells in another sheet when criteria met
for example the criteria in the first column in 2 sheet

explanation

salary = value1+value2 where name is equal in 2 sheets

CODE
Sheet1
Name          salary
a                 value1+value2 where name is equal in 2 sheet
b
c


sheet2
CODE
Name          value1              value2
a                    10                  20
b                     15                 16

This post has been edited by access2009eg: Nov 18 2019, 08:34 PM
Attached File(s)
Attached File  Book1.zip ( 6.97K )Number of downloads: 1
 

--------------------
I would like to Thank you for your help
Go to the top of the page
 
Debaser
post Nov 19 2019, 03:35 AM
Post#2



Posts: 156
Joined: 11-October 18



In B2:

=SUMPRODUCT((Sheet2!$A$1:$A$4=A2)*Sheet2!$B$1:$C$4)

and copy down.
Go to the top of the page
 
access2009eg
post Nov 19 2019, 07:13 AM
Post#3



Posts: 1,134
Joined: 19-February 08



thumbup.gif


hat_tip.gif


thanks.gif

--------------------
I would like to Thank you for your help
Go to the top of the page
 
Debaser
post Nov 19 2019, 09:39 AM
Post#4



Posts: 156
Joined: 11-October 18



You're welcome. smile.gif
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    8th December 2019 - 07:43 AM