I am looking for a way to formulate the data in C19-24 as well as D19-24
using the information in A,B,C and D 1-4. Can someone please help with a
formula.

Thank you


A B C D
1 JAN JUNE 2 4
2 MAR JUNE 1 16
3 MAR MAR 2 2
4 FEB MAR 3 4

A B C D
19 JAN 2 4
20 FEB 5 8
21 MAR 8 26
22 APRIL 3 20
23 MAY 3 20
24 JUNE 3 20

column C
=SUMIF(A$1:A$4,A19,C$1:C$4)+SUMIF(B$1:B$4,A19,C$1: C$4)

column D
=SUMIF(A$1:A$4,A19,D$1:D$4)+SUMIF(B$1:B$4,A19,D$1: D$4)

Place formulas into row 19 of each respective column, and copy down.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

I am looking for a way to formulate the data in C19-24 as well as D19-24
using the information in A,B,C and D 1-4. Can someone please help with a
formula.

Thank you


A B C D
1 JAN JUNE 2 4
2 MAR JUNE 1 16
3 MAR MAR 2 2
4 FEB MAR 3 4

A B C D
19 JAN 2 4
20 FEB 5 8
21 MAR 8 26
22 APRIL 3 20
23 MAY 3 20
24 JUNE 3 20

This is a start but does not correctly calculate the answers in C19-24 or
D19-24.

"Luke M" wrote:

column C
=SUMIF(A$1:A$4,A19,C$1:C$4)+SUMIF(B$1:B$4,A19,C$1: C$4)

column D
=SUMIF(A$1:A$4,A19,D$1:D$4)+SUMIF(B$1:B$4,A19,D$1: D$4)

Place formulas into row 19 of each respective column, and copy down.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

I am looking for a way to formulate the data in C19-24 as well as D19-24
using the information in A,B,C and D 1-4. Can someone please help with a
formula.

Thank you


A B C D
1 JAN JUNE 2 4
2 MAR JUNE 1 16
3 MAR MAR 2 2
4 FEB MAR 3 4

A B C D
19 JAN 2 4
20 FEB 5 8
21 MAR 8 26
22 APRIL 3 20
23 MAY 3 20
24 JUNE 3 20