By mrosario on Tuesday, 15 October 2019
Posted in Excel
Replies 1
Likes 0
Views 8.1K
Votes 0
Hi there!
I am trying to run an excel formula and can't seem to figure it out. I have a column with a range of numbers in one tab and a column with a range of numbers in a separate tab. I am trying to create a formula, where it searches the first column and if it finds a match anywhere in the second column it adds/sums any/all amount(s) from another column in the second tab. Hope this makes sense! Thank you!
Try SUMIF or SUMIFS (not sure if it works across separate tabs)
https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post