Thread
:
Conditional Calculations???????
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
Posts: n/a
Conditional Calculations???????
SUMIF should work - try this:
=SUMIF(C$2:C$100,"S",B$2:B$100), and
=SUMIF(C$2:C$100,"J",B$2:B$100)
These assume items to row 100 - adjust as necessary.
Hope this helps.
Pete
Reply With Quote