View Single Post
  #1   Report Post  
Need Help eek
 
Posts: n/a
Default Nesting Sumif function

Hello, if anyone can, please help.

I'm trying to nest sumif so as to check one column and if it is true, check
another column and sum the total as per usual.

ie

if (A1:A6) equals "Blue" then sumif(B1:B6,F1:F6,C1:C6)

Could anyone help me out here?? {:-{


Kind regards
Jeff