View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
trward79 trward79 is offline
external usenet poster
 
Posts: 20
Default Counting with multiple variabels

I need help with counting items with two variables that have to be true to be
counted.

I need the code to check 'Warnings issued'!A:A where Axx='520' and check
'Warnings issued'!G:G where Gxx='VERBL' and if these are both true to count
and return the result in 'Data'!Cxx where 'Data'!Axx='520' and then do
entries for the rest of the companies in the same order.

* xx is a holder for the cell number.