View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geo Geo is offline
external usenet poster
 
Posts: 66
Default Simple Sumif formual with Criteria

Hello,
I'm a Novice at excel

I need a formula that can give me a total for a specific item when the
criteria is blank . There are multiple sheets and I would need it to update
automically as I add more sheets and Xs to the corresponding item. please see
ex. below

Column A Column B
Waiting For Model: Phone Ready
Muziq X
Fusic
Muziq
Fusic X
muziq
Moto Q
Fusic
Moto Q
Fusic
....... .....


So what I'm looking for is
Waiting For Model: Total
Muziq 2
Moto Q 2
Fusic 3


Thanks in advance