0
Undo
Votes
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!
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
https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
- Page :
- 1
There are no replies made for this post yet.