Simple Addition of Numbers using Criteria

[JonesyUK]

Hi - I have data in columns "P", "Q" & "R" as follows:
_______"P"__"Q"____"R"
Row22: P7 (9,178) 7,992
Row23: P7 251,253 93,239
Row24: P8 (10,017) 8,879
Row25: P8 241,277 103,603
Row26: P9 (9,715) 8,342
Row27: P9 244,506 97,423
Row28: P10 (9,522) 7,109
Row29: P10 217,718 84,952
Row30: P11 (9,390) 7,602
Row31: P11 218,933 90,884
Row32: P12 (8,754) 7,617
Row33: P12 226,054 91,116

Please help me with a formula.

Depending on the month(P1 to P12), I need to sum up any data that relates to that month, so if it is P8, then I need to sum up 8,879+103,603 (please ignore the data in column "Q"). If the month is P10, then I need to sum up 7,109+84,952.... etc.

The formula goes into cell R35.

Thanks!!!

 

[VoG]

For P7 try

=SUMIF(P22:P33,"P7",R22:R33)

 

[bosco_yip]

=SUMIF(P22:P35,"P8",R22)

Regards

 

[SIGE]

=SUM((P22:P23="P8"))*(R22:R33)) enter with Ctrl+Shift+Enter

=SUMPRODUCT(--(P22:P23="P8");R22:R33)

 

[JonesyUK]

For P7 try

=SUMIF(P22:P33,"P7",R22:R33)

Many thanks, perfect!