Separate totals from spreadsheet

[Orangeanorak]

I have a sheet of 100 lines

Some are marked Gift Aid - some are not named

What formula do I need to provide a total for the Gigt Aid columns and a separate total for the not named

Thanks

 

[just_jon]

Try SUMIF -- assuming the Gift Aid bit is in column a -

=SUMIF(A1:A100,"Gift Aid",B1:B100)

=SUMIF(A1:A100,"<>Gift Aid",B1:B100)

The 1st will sum B1:B100 if the corresponding A cell is equal to "Gift Aid"; the 2nd formula sums everything else.

 

[Orangeanorak]

Thanks Jon

All sorted