Thread: Is SUMIFS the right forumula to use?
View Single Post
 
Old 12-15-2016, 07:50 AM
Nanaia Nanaia is offline Windows XP Office 2013
Novice
  
Join Date: Dec 2016
Location: Lexington, KY
Posts: 10
Nanaia is on a distinguished road
Default Is SUMIFS the right forumula to use?
I'm trying to use the SUMIFS formula to total the number of shop hours each month out of the list of all the offers we've made. When I use the SUMIFS I keep getting 0 as the total. Can you help me figure out what I'm doing wrong?
I've attached a screen shot of my worksheet.
Nanaia
Attached Images
File Type: png ExcelShot.PNG (37.6 KB, 46 views)
Attached Files
File Type: xlsx Fab Estimator Chart-test.xlsx (32.7 KB, 9 views)
Last edited by Nanaia; 12-15-2016 at 10:44 AM.
Reply With Quote