|
|
#2
11-27-2016, 09:53 PM
|
|||
|
|||
If your headings start in A1 then put this formula in C2 and copy down:
=IF(COUNTIF($B$2:B2,B2)=1,SUMIF($B$2:$B$20,B2,$C$2 :$C$20),"") (For another time please remember that the actual Excel file with data is much more helpful than a picture). 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with SUMIFS | OTPM | Excel | 8 | 05-27-2016 07:54 AM |
| Sumifs | lynchbro | Excel | 1 | 07-02-2014 09:27 AM |
 Help with SUMIFS
|
LeFoah | Excel | 2 | 10-20-2013 09:22 AM |
|
I need help with =SUMIFS
|
docwhit | Excel | 2 | 01-05-2013 12:58 PM |
|
SumIFS Questions
|
Kheinrich119 | Excel | 2 | 12-12-2012 10:00 AM |
Windows 10 
Office 2016
Threaded Mode