Hi all,
I have a formula I am trying to resolve:
=SUMIF(HG3:HG32, "<>#N/A")
I want to add a bit to formula to take into account and sumif a cell in range hk:3:hk32 has a 'Yes' How do i this?
I guess I am needing a SUMIFS or something like =SUMIFS(HG3:HG32, "<>#N/A", HK3:HK32, "Yes")
thank you
Bookmarks