Forum Discussion
Nhat_Nguyen
May 09, 2022Copper Contributor
Combining formula?
Hi all,
I have a question regarding adding 2 formula together. See below.
So basically I'm trying to sum up the amount of hazardous waste generated in certain months only, in this case April. I can count the amount of waste drums that we have each month - cell M60 using =SUM(IF(MONTH(L49:L57)=B49,1)) with B49 has a hidden number 4 since I don't want to show that 4 on the spread sheet (I think I can also do =TEXT(dates,"mmmm") and then COUNT, but I want to keep it simple so my coworker can understand). But when calculating the weight of all those drums, I can't seem to write one single formula. If you look to the side, there's an array with "FALSE" and "1", because I use =IF(MONTH(L49:L57)=B49,1) and then in R51 I write =SUMIF(P51#,1,N49:N57), and it returns a value of 507 as 507=119+143+110+135. The first entry in the table (cell L49 with 02-17-22) is the drum from February so we don't count it. My question is, can I just write one single formula in N60 to find the total weight, instead of doing 2 steps like this? Right now it says N60=119 because it's =N50. I tried combining them but it didn't work. Any help would be appreciated. Thanks in advance.
- OliverScheurichGold Contributor
- Nhat_NguyenCopper ContributorThank you so much. It worked perfectly.