Hello
I want to put my formula on sheet1 and reference columns on sheet2 for example
=sumif(Sheet2!H2:H15=1,and if sheet2!J2:J15=9,sheet2!g2:g15))
Basically I want to have the sumif check column H for the #1 AND aslo check
Column J for the #9 and if it finds both numbers in any one row to grab the
figure from the G column and put it on Sheet1.
I tried different variations and I get either #REF or #NAME and sometimes
the "File not found" window pops up when I try to place the formula.
I know how to write a one senaro SUMIF but I get confused when I want it to
check two columns and if it finds the #1 and the #9 in two columns to carry
out the SUMIF.
Thank you
--
He4Giv (****)
Bookmarks