Checking if sum of multiple rows equals total in another.

Hello,

I am trying to check whether the sum of a number of rows equals the total in a single cell located elsewhere on the spreadsheet.

I have attached a cell sheet to make it easier.

Thanks for any help on this!

Or ...

=SUMIFS($D$2:$D$10,$C$2:$C$10,F2)=B2

Hi

Just another option on this to add formula in G2:

=IF(SUMIF(C:C,A2,D:D)=B2,TRUE,FALSE)

Or if you want to add specific ranges and add absolute references for when you're copying down you could use:

=IF(SUMIF($C$2:$C$10,A2,$D$2:$D$10)=B2,TRUE,FALSE)

Both options above work also so this is just another option. Cheers

Richard

Thanks for the answers. These work great!!