View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Search across multiple sheets and subtotal.

The SUMIF worksheet function may help. You need one for each sheet and then
you can sum them to get the great total. Example where the numbers in
L1:L20 that have "xx" in column K are summed:

=SUMIF(K1:K20,"xx",L1:L20)

--
Jim Rech
Excel MVP