Thread: flipping a spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default flipping a spreadsheet
Hi,

Something along these lines ...

=SUMIF(A2:A100,"="&D2,E2:E100)

Ranges A2:A100 and E2:E100 are the ones located in Sheet1, whereas the
formula is located in sheet 2 cell D3 ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote