Thread: SUMIF division
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default SUMIF division

From Sheet 2, I'd like a formula to calculate the following using an array:

If Sheet1 Column A = Sheet2 Column A
AND
If Sheet1 Column K 0
THEN
Divide Sheet1 Column K by Sheet1 Column L

Can anyone help? Thanks.

Bob