Solved Summing up in excel

February 1, 2014 at 14:56:29
Specs: Windows
How do u sum up values of the same date but the entries are in different worksheets with excel eg
Worksheet 1 shows revenue for cyber, worksheet 2 shows revenue for scratch cards. How do u sum the daily revenues for same date in work sheet 3?

See More: Summing up in excel

Report •

February 1, 2014 at 20:40:30
✔ Best Answer
You can SUM multiple SUMIF's.

e.g. With your date in Sheet3!A1, this formula should work in Sheet3:


Another method, using SUMPRODUCT and INDIRECT is shown here:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question