LinkBack URL
About LinkBacks
This is probably one of the all time questions but, I have two cells CI4 DB4 that I wish to multiply. I tried a variant of wishful thinking but it doesn't seem to work.
=SUMproductIF(CI4,DB4,"<>#N/A")
Any help would be much appreciated,
Cheers,
This is probably one of the all time questions but, I have two cells CI4 DB4 that I wish to multiply. I tried a variant of wishful thinking but it doesn't seem to work.
=SUMproductIF(CI4,DB4,"<>#N/A")
Any help would be much appreciated,
Cheers,
Last edited by Joah; 01-21-2013 at 08:32 PM.
Hi,
Perhaps
Formula:
=IFERROR(CI4*DB4,"")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Man, I just love it when it's that easy.
Post a question, take a nap, turn screen back on and presto!
Cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks