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?

You can SUM multiple SUMIF's. e.g. With your date in Sheet3!A1, this formula should work in Sheet3:

=SUM(SUMIF(Sheet1!$A$1:$A$6,A1,Sheet1!$B$1:$B$6),

SUMIF(Sheet2!$A$1:$A$6,A1,Sheet2!$B$1:$B$6))Another method, using SUMPRODUCT and INDIRECT is shown here:

http://www.xl-central.com/sum-singl...

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

message edited by DerbyDad03

Ask Your Question

Weekly Poll