Thread: Help! 'SUMIF' Formulas
View Single Post
 
Old 09-07-2011, 07:53 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
you need multiple ifs...
=SUMIFS($D$2:$D$16;B$2:B$16;1;C$2:C$16;"Mr A")
Attached Files
File Type: xlsx sample.xlsx (9.1 KB, 11 views)
Reply With Quote