I have a table with acct headings accross the top (sheet 3 row 3) and companies down the right side (sheet 3 column A). I’m trying to write a forumla that say, if in column d on sheet 1 contains company A, and if on column f contains account X, sum the value in column c from sheet 1.
So currently my forumla looks like this, but it is not correct, b/c if it sees one or the other it is capturing it.
=IF(‘sheet1!$D:$D=Sheet3!$A7,(SUMIF(‘sheet1!$F:$F,Sheet3!B$3,’sheet1!$C:$C)),0)
Thanks.