Hello, my formula is supposed to:
add 4 cells (A1,C1,E1,G1)
then divide (X1) and
then multiply by *5
then ignore blanks or errors.
I did something like this: =SUMIFS(A1,C1,E1,G1/X1*5,">0")
Can someone please tell me what I'm doing wrong?
Hello, my formula is supposed to:
add 4 cells (A1,C1,E1,G1)
then divide (X1) and
then multiply by *5
then ignore blanks or errors.
I did something like this: =SUMIFS(A1,C1,E1,G1/X1*5,">0")
Can someone please tell me what I'm doing wrong?
This:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Let me try that. thank you. I'll find out if that works. I'll be back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks