View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GavinS GavinS is offline
external usenet poster
 
Posts: 18
Default SUMIFS, one criteria range, multiple criteria

I have the following data

Column A Column B
Amount Account
100 A
50 B
20 C
200 D

I would like to sum items in column A where column B = B or C (I think
these are numbers stored as text).

I cannot get SUMIFS to work with multiple criteria but only one
criteria range even when I use the OR statement.
Can someone help me how to do this please.

thanks