Excel 2010: using SUMIF and adding up two columns of data

[pendle666]

Hello

I am sure this is simple, but can't think of how it's done.

I've currently got:

=SUMIF(A48:A88,"Jo Bloggs",E48:E88)

to add up some figures, but what I want is to calculate E48:E88 and F48:F88, I've tried:

=SUMIF(A48:A88,"Jo Bloggs",E48:F88)

but it doesn't work, just adds up the first column and SUMIFS gives me errors.

Any ideas?


thank you!

thank you for helping

____________
Pendle

 

[combo]

If in col. A you have values to compare with criteria and need to sum columns E and F, use two SUMIF in formula: =SUMIF(A48:A88,"Jo Bloggs",E48:E88)+SUMIF(A48:A88,"Jo Bloggs",F48:F88)

combo

 

[pendle666]

Righto, thank you!

thank you for helping

____________
Pendle