I have a formula listed below that works searches the identified column, the highlighted larger font section, has blanks I would like it to recongnize, because it will be sheet that is constantly replaced I do not want to add "" or 0, but recognize the actual blank cell, a column with identified next to it in larger font contains an amount that I want to be identified. (Excel 2007)
=SUMIFS('YTD Actual Data'!$G$2:$G$46404,'YTD Actual Data'!$C$2:$C$46404,L$5,'YTD Actual Data'!$E$2:$E$46404,$B$3,'YTD Actual Data'!$H$2:$H$46404,$B36)*$A36
I need the proper syntax to include the isblank within to provide the necessary operations. thank you in advance for your assistance in this effort have a great day. Thank you in advance for any assistance you can provide.
=SUMIFS('YTD Actual Data'!$G$2:$G$46404,'YTD Actual Data'!$C$2:$C$46404,L$5,'YTD Actual Data'!$E$2:$E$46404,$B$3,'YTD Actual Data'!$H$2:$H$46404,$B36)*$A36
I need the proper syntax to include the isblank within to provide the necessary operations. thank you in advance for your assistance in this effort have a great day. Thank you in advance for any assistance you can provide.