Microsoft Office Forums - View Single Post - Multiple IF formulas that are not nested still returning #VALUE!

Thread: Multiple IF formulas that are not nested still returning #VALUE!

View Single Post

Old

03-22-2020, 09:53 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

I am not sure if I understood what you wanted but how about this

Code:

=SUMPRODUCT(A$2:A$10,B$2:B$10*(B$2:B$10>0))

Reply With Quote