Formula to sum up occurrences from multiple worksheet

S

Shaggy123

New Member
Joined
Oct 18, 2017
Messages
10
Hi Excel Gurus!

Can someone help me with a formula please
I have a worksheet that counts employee sales for a day and sums it up. my dilemma is to count sales for those particular employees with sales on a different worksheet
For e.g. Larry had sales for january and march, Scott had sales from february and april... on summary sheet i need to display their names with their sales totals (only those with sales)

1611569147699.png
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Please upload your example file (one Sheet with 10 rows) & Desired Results (Total with Result Structure) with XL2BB ADDIN (Preferable) OR upload it at free uploading site e.g. www.dropbox.com or googledrive or onedrive and insert link here.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Vlookup from multiple tabs at same time
Replies
3
Views
287
Fluff
Fluff
X
  • Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
251
KRice
K
K
  • Question
How to find matching numbers in one column and add data from another column
Replies
6
Views
760
kyleax1
K
L
  • Question
How would I determine the employees working at the time of each retail transaction by comparing that transaction timestamp with employee shift times?
Replies
1
Views
744
SanjayGMusafir
SanjayGMusafir
N
  • Question
What is the formula used to calculate sum of sales value from data dump with multiple conditions?
Replies
3
Views
230
etaf
etaf

Forum statistics

Threads
1,214,584
Messages
6,120,387
Members
448,956
Latest member
JPav

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top