View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default SUMIF with 2 conditions

Oops, didn't even notice I had dropped those in the copy.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Vito" wrote in message
...

Bob Phillips Wrote:
Maybe wrap-around.

Try copying

=SUMPRODUCT(--('Stock Issues'!G2:G200=$A$1),
--('Stock Issues'H2:H200=B1),'Stock Issues'F2:F200)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"1990" wrote in
message
...

Thanks for the reply, but when i copy that in it brings up an error
message and highlights the second 'Stock - highlighted in red here

"
=SUMPRODUCT(--('Stock Issues'!G2:G200=B1),--('Stock
Issues'H2:H200=$A$1),'Stock Issues'F2:F200) "


--
1990

------------------------------------------------------------------------
1990's Profile:

http://www.excelforum.com/member.php...o&userid=30100
View this thread:

http://www.excelforum.com/showthread...hreadid=497851



The exclamation points are necessary after *each* reference to a
worksheet.

=SUMPRODUCT(--('Stock Issues'!G2:G200=$A$1),--('Stock
Issues'!H2:H200=B1),'Stock Issues'!F2:F200)


--
Vito
------------------------------------------------------------------------
Vito's Profile:

http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497851