All,
I've looked at a lot of the previous posts on this subject and have tried multiple things, but obviously not the right one. So I've got this table from another source, (Unknown), and am trying to add up like areas and work. I've had to separate many of the different areas that work is being done and the first tab I created worked perfectly. The second one does not.
I've got a column identifying three different sections and I'm using the SUMIF function to add up area and work. I've cut out a small piece of the entire thing. You can see that the total adds up and the SUMIF for the E & M sections work; however, the R section does not sum the values in the sheet.
I'd appreciate it if someone could check it out and let me know what boneheaded mistake I'm making.
Thanks
Bookmarks