SUM cells based on corresponding cells

[RevJeff]

Below is an example of what I am trying to do. The FY SUM adds up the entire year for both FY16 & FY17, but the Comparison SUM adds up only the FY17 months that have data and I want the FY16 to only SUM the comparison month where FY17 has data and to adjust as data is added to FY17 months. I just can't figure out how to compare the FY's months to look for data.

Hopefully that makes sense.


Yr FY16 FY17
Jan 13 14
Feb 45 39
Mar 33 30
Apr 17 18
May 23 21
Jun 12 14
Jul 8 0
Aug 7 0
Sep 16 0
Oct 19 0
Nov 29 0
Dec 44 0
FY SUM 266 136
Comparison Sum 143 136

[jaslake]

Hi Rev

Try this...based on your Original Sample Data...

Row\Col

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

1

**Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

FY SUM

Comparison Sum

2

**FY17

14

39

30

18

21

14

=SUM(B2:M2)

=SUM(B2:M2)

3

FY16

13

45

33

17

23

12

8

7

16

19

29

44

=SUM(B3:M3)

=SUMIFS(B3:M3,B2:M2,"<>")

[RevJeff]

That's perfect! Thank you!

[jaslake]

Hi Rev

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.