<div>
Thanks for the excellent feedback...
</div>


<div>
<div class="content wysiwyg-content">
hi experts using excel 2010<br />
<br />
i have the following sumifs formula working fine....<br />
=SUMIFS(Sheet2!$J$7:$J$100<wbr />00,Sheet2!<wbr />$C$7:$C$10<wbr />000,'Sheet<wbr />1'!B19,She<wbr />et2!$B$7:$<wbr />B$10000,'S<wbr />heet2'!C19<wbr />)<br />
<br />
I want to add Sheet2 $G7:$G10000 and Sheet1 G19<br />
<br />
excel
</div>
</div>


hi experts using excel 2010

i have the following sumifs formula working fine....
=SUMIFS(Sheet2!$J$7:$J$10000,Sheet2!$C$7:$C$10000,'Sheet1'!B19,Sheet2!$B$7:$B$10000,'Sheet2'!C19)

I want to add Sheet2 $G7:$G10000 and Sheet1 G19

excel

sumifs with addtional step

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.