Hi guys,
As in the attached example, I want to set a criteria with sumif formula to summarize the numbers in column B if the related letter in Column A is not included in the range E3:E6
Thank you in advance
Hi guys,
As in the attached example, I want to set a criteria with sumif formula to summarize the numbers in column B if the related letter in Column A is not included in the range E3:E6
Thank you in advance
Try in F3 copied down...
=SUMIF($A$2:$A$11,"<>"&E3,$B$2:$B$11)
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks