I need to find the sum of all the values in column B, which have a value in Column A between 74 and 301.
Example (first column is A, second is B:
0 1 50 2 60 3 100 4 200 5 250 6 299 7
Expected answer would be:
4+5+6+7=22
I have a feeling I need the SUMIF function, but other than that I just can't wrap my head around it.
Try this one
=SUMIFS(B1:B7,A1:A7,">74",A1:A7,"<301")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks