Software

Ask something
Discussion Locked

Excell Function

0 helpful
5 replies

by wandering

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
If I have two identical worksheets why can't I use the sumif function to sum identical columns from both worksheets based on criteria from one worksheet? I get the #VALUE error. Column A on both spreadsheets have a list of identical names that are repeated down the column. Column B on both spreadsheets have different amounts for each name. I want to add the different amounts based on looking for one particular name.

5 replies

by dklippert

You can add the two Sumif's
=SUMIF(Sheet1!A2:A10,"Fred",Sheet1!B2:B10)+SUMIF(Sheet2!A2:A10,"Fred",Sheet2!B2:B10)

by wandering

Thanks. I knew I could do two separate sumif's and add together which is how I currently was doing it, but I was hoping there was a way to include both worksheets in one statement.

This discussion is closed to new replies.