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

hi,

I have a worksheet in which there are lot of formulas like this:

SUMIF('OtherWorksheet'!$A:$A,$A12&D$2,'OtherWorksh eet'!$X:$X)

can someone help me interpret this? also, is there a better approach or way
to do this as opposed to having a worksheet full of these SUMIF functions?

thanks in advance,
geebee