SUMIF Multiple Sheets

G

Guest

I am trying to use a SUMIF statement to sum the values in cell C2 over
multiple sheets if the value in A2 is a 1 but am continuing to get an error
message. Here is the formula I am using
"=SUMIF(Sheet2:Sheet56!A2,1,Sheet2:Sheet56!C2)". Any help would be greatly
appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF using 2 cells that equal each other 1
SUMIF with multiple sheets 5
Does SUMIF work over multiple worksheets? 18
SUMIF with multiple conditions 5
SUMIF and <> 5
SUMIF function and cell /sheet reference 3
EXCEL - IF(IFERROR(VLOOKUP question 0
SUMIF, use List as a Range 2

Top